How do I resize a worksheet after deleting rows?

J

Jay Jay

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?
 
J

Jay Jay

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