If I start with a large file (say 5000 rows, 1MB in size) and delete all but 5 rows, the file is still saved as 1MB. If I hit the “End” button, it goes to row 5000 even though rows 6 – 5000 are blank. Is there a way to move the “end” of the file up to row 5? I have just copied rows 1-5 to a new file and resaved in the past to shrink the file but this is a pain if there are multiple tabs.
Thanks,
Bobby
