| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting a rows from multiple worksheets | Excel Worksheet Functions | |||
| How to increase the maximum rows in the worksheet? | Excel Discussion (Misc queries) | |||
| Deleting rows with blank cells | Excel Worksheet Functions | |||
| deleting multiple rows | Excel Discussion (Misc queries) | |||
| increasing the number of rows of a worksheet beyond 65536? | Excel Discussion (Misc queries) | |||
Linear Mode
