Eliminated unused cells

[Geek]

Hello,

I would like to know if it is possible to eliminate unused cells or do I
just hide them. I sent out a calendar of events that I created using excel.
When others open and try to print it, they can print out the schedule but
then it wants to print over 2000 pages of just the header and nothing else.
I deduce it is detecting all those unused cells and thus thinking I want
those printed.

I do know how to set the print area and that does correct the problem.
However, I was thinking that there must be something else I can do so that I
don't have to set a print area each time I create a book.

Thanks.

 

[Bernie Deitrick]

Geek,

Go to what you think should be the last cell in your spreadsheet
(bottom right). Then move one cell down, hit Shift-Ctrl-End, then use
Edit | Delete... "Entire Row" then OK. Go to your presumptive last
cell again, move one cell right, hit Shift-Ctrl-End, then use Edit |
Delete... "Entire Column" then OK. Then save the workbook, close it,
and re-open it. Use Ctrl-End and see where your cursor ends up.

HTH,
Bernie
MS Excel MVP