Mon 15 Oct 2007, 12:13Delegate Tim said...
Tim has attended:
Excel Advanced course
Making a large file smaller
Hi
I have a file that thinks it is 65536 rows when actually it is only 175 rows deep - how do I completely delete those extra rows, so that the file will be a lot smaller?
Wed 17 Oct 2007, 08:54Trainer Pete said...
RE: Making a large file smaller
Hi Tim, I can only assume that you have an entry somewhere in the final row of your worksheet, if this is the case, go to the first column of the row beneath your last row (176) select that entire row, then use the keyboard combination CTRL+Shift+Down Arrow to select all rows and columns beneath and then use Menu Command Edit, Clear All. Hope that works...
