Hi,
I had a data sheet that used about 20,000 rows, down to AF20000 or so. I deleted about 16,000 rows and now want to reduce the size of the worksheet so that when I hit Control+Shift+End, it takes me only to AF4000, not to AF20000. Can this be done without replicating into a new worksheet?
Thanks,
Jim
Last edited by Kuehl5000; 01-13-2014 at 06:30 PM.
Did you try deleting the rows (not simply emptying them but rather deleting the entire rows) and then saving the file?
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Tried that first, to no avail.
It is usually sufficient. Have you closed and reopened the workbook?
Well I have now... and it worked. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks