Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I keep from printing blank pages in excel?
I'm trying to print only rows containing nonzero values in a specific column.
I can filter the data to show only rows with nonzero values but I am then forced to reset my print area or I get blank pages. Is there an easier way? Thanks. |
#2
|
|||
|
|||
You could press Ctrl-* to select just the current region, then use Print
Selection, rather than simply Print. You can probably even record a macro incorporating those steps to speed it up. "Davbwalker" wrote: I'm trying to print only rows containing nonzero values in a specific column. I can filter the data to show only rows with nonzero values but I am then forced to reset my print area or I get blank pages. Is there an easier way? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I mirror pages in an excel document for printing? | Excel Discussion (Misc queries) | |||
Excel Printing Trash | Excel Discussion (Misc queries) | |||
print excel columns on less pages | Excel Discussion (Misc queries) | |||
Excel Printing and Page Setup | Excel Discussion (Misc queries) | |||
Excel program not printing all pages... | New Users to Excel |