Suppress printing of hidden columns

  • Thread starter Thread starter Gary Potvin
  • Start date Start date
G

Gary Potvin

I have a worksheet that is set up with page breaks between
every column. Some columns are hidden, and I have a column
that repeats on each page. I've selected all visible
rows/columns in my print area, but when I preview/print, I
am getting pages for each of the hidden columns that have
just the repeated column heading but no data. Do you know
of any way to suppress printout for hidden columns?
 
Excel still respects those pagebreaks.

So I'd either remove them or copy the visible cells/columns to a different
worksheet and print from there.
 
Back
Top