How do I omit rows containing nozero values when printing in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to conditionaly hide rows from printing based on values in a
paticular column of my worksheet. Is this possible? Thanks.
 
I find the easiest way to do this is to apply Data|Filter|Autofilter to my
range.

Then I use the filter to show/hide what I want.
Then I print
and then Data|Filter|Showall to see everything again.
 
The problem is that I have a range of 4 pages of info, so if I autofilter
and the data I want is at the top and bottom of the range, then I get 2 pages
containing half of the info I want and 2 blank pages between them. Is there
any way around this without reseting all page breaks and print areas? Thanks
again for your help.
 
It sounds like you've added some manual page breaks to your worksheet.

You could clear those manual page breaks and do the autofiltering, then print.

Or you could do the autofilter and copy to a new worksheet--then print from
there (and delete the sheet when you're done.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i omit rows for printing based on column value 1
conditional formatting 1
Blank Sheet with Gridlines 11
Hide and Show Rows based on Cell Value 2
Excel VBA 1
How to print worksheet and automatically hide zero value rows? 3
Hide row before printing 3
Dynamic Print Range with cells containing formulas ! 1

Back
Top