Hidden columns

A

Amste

I have hidden columns in my spreadsheet and do not want these to print when I
print the spreadsheet, how is this done?
Thanks
 
A

Amste

Thanks for your response however I have tried that already and they do print.
Any other suggestions?
 
P

Pete

If you change the foreground colour to the background colour for the
columns you do not want to see, then they should not appear on a
printout. This does not really fix your problem, though.

Pete
 
R

Richard9278

Are you, by any chance, "hiding" them by letting them scroll off the
screen and then setting Frames?

Rick
 
R

Richard9278

Amste, Try right clicking on the column heading for the column you wish
to hide and choosing "Hide" on the menu that appears. To unhide,
highlight the two columns headings on either side, right click
somewhere in the two column headings and choose "Unhide".
 
G

Gord Dibben

Amste

How do you hide a column by dragging it?

Drag to where?

I might learn a new trick here<g>


Gord
 
A

Amste

Hi Gord,
The right way to hide columns so they won't print is by right clicking and
choosing hide columns. I was highlighting the columns I wanted to hide and
dragging them to the next column so they wouldn't appear however, they will
print when you do this.
Thanks for your help.
 
G

Gord Dibben

I was wondering if you just changed the width and did not actually hide them.

Now I know.

Thanks, Gord
 
Top