How do I resize a worksheet after deleting rows?
 

After deleting rows in a spreadsheet Excel seems to remember the blank rows,
and will try to print them unless I reset the print area. Also, when I
subtotal the grand totals appear after the blank rows. Is there a way to
re-set the size?

Save the workbook after deleting the Entire rows and before printing.

--
Regards,
Tom Ogilvy


"Jay Jay" wrote in message
...
After deleting rows in a spreadsheet Excel seems to remember the blank
rows,
and will try to print them unless I reset the print area. Also, when I
subtotal the grand totals appear after the blank rows. Is there a way to
re-set the size?

Thanks so much Tom. I just knew it had to be simple, but I've asked lots of
users who didn't know.

"Tom Ogilvy" wrote:

Save the workbook after deleting the Entire rows and before printing.

--
Regards,
Tom Ogilvy


"Jay Jay" wrote in message
...
After deleting rows in a spreadsheet Excel seems to remember the blank
rows,
and will try to print them unless I reset the print area. Also, when I
subtotal the grand totals appear after the blank rows. Is there a way to
re-set the size?