| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I automatically print subtotal on last row of every page?
I have to print a report, containing a few hundred rows of numerical data. I
want Excel to automatically print subtotals of each column at the bottom of each printed page. I can do it manually, by counting the number of rows that would fit on a page, and adding the subtotals at the correct position. But, as soon as you add or delete rows in your ranges, you have to change all your subtotals again. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
| automatically roll the page number after you print | Excel Worksheet Functions | |||
| Create a print macro that would automatically select print area? | Excel Worksheet Functions | |||
| subtotal by page | Excel Worksheet Functions | |||
| Automatically print all page contents in pivot table. | Excel Worksheet Functions | |||
Threaded Mode
