Shirley
You have to do this for each sheet of your file. Let's say that you
have looked at the sheet and you have determined that your last cell is G50.
Select row 51. You do this by clicking on the 51 in the column of row
numbers at the left side of the screen. This selects the entire row.
Now do Ctrl-Shift-Down Arrow (Hold down the Ctrl and Shift keys and hit the
down arrow key). You just selected every row from row 51 to the last row,
row 65,536.
Now place the mouse pointer anywhere in the blue (selected) area,
right-click, and click on Delete. This deletes all those rows, which are
immediately replaced with new blank rows.
Now select the H column by clicking on the H at the top of the column. Do
Ctrl-Shift-Right Arrow. Right-click anywhere in the selected area and click
on Delete.
Now do the same thing in the rest of the sheets. Save the file. Close the
file. Go into Explorer and see how big it is. Let me know if this works
for you.
If you have lots of sheets, there exists code to automate this process.
Now open the file and do Ctrl-End on each of the sheets and see where it
takes you.
It would be prudent to try all this on a copy of your file first. HTH
Otto