Suppress printing of hidden columns

[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?

 

[Dave Peterson]

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.