Hi Missy,
The need to hide rows is a clear indication that you have a last cell
problem. You can mask the fact by hiding rows, or reducing the
print area, but the best solution would be to correct the problem.
If you put a space or a formula into a cell then that cell is occupied
and is by definition not empty.
A bad practice that some people do is to put a calculation in some
out of the way location and mask the fact with white font color. That
plays havoc as it expands the spreadsheet and the cells to be display
and to be printed.
Unhide what you hid: Ctrl+A, Format, rows, unhide
to find the last cell:
Ctrl+End that should select a cell at the intersection of the
last used row and the last used column.
I expect you will find that cell to be not what you expected. You
would probably need to delete unused rows and columns past
where your data, and then save the file. If you are using a macro
if it seldom necessary to actually save the file (see code in macro).
Take a look at macros in
Reset Last Used Cell
http://www.mvps.org/dmcritchie/excel/lastcell.htm#resetall
specifically #resetall and #makelastcell
You can also read about the cause of the problem.
Inserting rows or columns and then deleting rows or columns,
where Excel has not fixed the last row indication.
Suggest working a copy of your worksheet or of your workbook.
You might also want to look in your directory to see the size of
your file before and after. Or you can look in File, properties
form within Excel.
