How to stop empty columns from printing

  • Thread starter Thread starter Mark Christensen
  • Start date Start date
M

Mark Christensen

Hello,

My spreadsheet uses columns A-G, but when I print, column H also prints even
though there is nothing in any of its cells. There is no print area set.
Why is this empty column printing? And how do I stop it from printing? TIA.

Mark
 
My spreadsheet uses columns A-G, but when I print, column H also prints even
though there is nothing in any of its cells. There is no print area set.
Why is this empty column printing? And how do I stop it from printing? TIA.
Click to expand...

Hide column H before printing.
 
I'm looking for more of a permanent solution because this file will be
shared and others may print and I don't want to have to rely on them to
leave the column hidden.
 
If H is empty, why the concern?

Just change the margin settings inward and set to center horizontally.


Gord Dibben MS Excel MVP
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Need Countifs Formula Help 0
Single column to multiple columns 5
Preventing Column Cell Values from Printing 10
Printing a large/long spreadsheet on legal size paper problem 1
How to set cell value to emptry if three other columns are empty too 1
Row heights change when printing bug? 1
How to print only selected columns from a worksheet 1

Back
Top