Forum Discussion
Deleting mega-rows
I have an excel spreadsheet that has data in the first two pages based on my sheet size, etc. When I go to print the file, the print screen shows that I have 133 pages to print! Well that just ain'...
First, back up your file in case you inadvertently delete something you need.
You could try selecting an entire empty row just below your actual data, then hit Ctrl+Shift+Down Arrow, then on the Home tab click Clear/Clear All. Same thing with the columns, but using Ctrl+Shift+Right Arrow. Then save the file.
You could try selecting an entire empty row just below your actual data, then hit Ctrl+Shift+Down Arrow, then on the Home tab click Clear/Clear All. Same thing with the columns, but using Ctrl+Shift+Right Arrow. Then save the file.