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.
 

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

Back
Top