How to stop empty columns from printing

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
 
Z

Zilbandy

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.
 
M

Mark Christensen

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.
 
B

Bernard Liengme

If H is truly empty it will not print, so delete H and try again
best wishes
 
G

Gord Dibben

If H is empty, why the concern?

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


Gord Dibben MS Excel MVP
 
Top