Hidden columns
 

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

Hidden columns
 

Keep them hidden.

They won't print.


Gord Dibben Excel MVP

On Wed, 30 Nov 2005 12:57:11 -0800, "Amste"
wrote:

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

Hidden columns
 

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

"Gord Dibben" wrote:

Keep them hidden.

They won't print.


Gord Dibben Excel MVP

On Wed, 30 Nov 2005 12:57:11 -0800, "Amste"
wrote:

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

Hidden columns
 

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

Hidden columns
 

Have no other suggestions because hidden columns normally do not print.


Gord

On Wed, 30 Nov 2005 13:51:11 -0800, "Amste"
wrote:

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

"Gord Dibben" wrote:

Keep them hidden.

They won't print.


Gord Dibben Excel MVP

On Wed, 30 Nov 2005 12:57:11 -0800, "Amste"
wrote:

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

Hidden columns
 

How are you hiding the columns?


--
Richard9278
------------------------------------------------------------------------
Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770
View this thread: http://www.excelforum.com/showthread...hreadid=489581

Hidden columns
 

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

Rick


--
Richard9278
------------------------------------------------------------------------
Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770
View this thread: http://www.excelforum.com/showthread...hreadid=489581

Hidden columns
 

by dragging them


"Richard9278" wrote:


How are you hiding the columns?


--
Richard9278
------------------------------------------------------------------------
Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770
View this thread: http://www.excelforum.com/showthread...hreadid=489581

Hidden columns
 

Might not fix the problem but is a good suggestion, thanks!


"Pete" wrote:

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

Hidden columns
 

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




Amste Wrote:
by dragging them


"Richard9278" wrote:


How are you hiding the columns?


--
Richard9278

------------------------------------------------------------------------
Richard9278's Profile:
http://www.excelforum.com/member.php...o&userid=28770
View this thread:
http://www.excelforum.com/showthread...hreadid=489581




--
Richard9278
------------------------------------------------------------------------
Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770
View this thread: http://www.excelforum.com/showthread...hreadid=489581

Hidden columns
 

Amste

How do you hide a column by dragging it?

Drag to where?

I might learn a new trick here<g


Gord


On Wed, 30 Nov 2005 16:35:02 -0800, "Amste"
wrote:

by dragging them


"Richard9278" wrote:


How are you hiding the columns?


--
Richard9278
------------------------------------------------------------------------
Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770
View this thread: http://www.excelforum.com/showthread...hreadid=489581

Hidden columns
 

Hi there,
I tried this and it did work, thanks a lot for your help.


"Richard9278" wrote:


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




Amste Wrote:
by dragging them


"Richard9278" wrote:


How are you hiding the columns?


--
Richard9278

------------------------------------------------------------------------
Richard9278's Profile:
http://www.excelforum.com/member.php...o&userid=28770
View this thread:
http://www.excelforum.com/showthread...hreadid=489581




--
Richard9278
------------------------------------------------------------------------
Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770
View this thread: http://www.excelforum.com/showthread...hreadid=489581

Hidden columns
 

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.


"Gord Dibben" wrote:

Amste

How do you hide a column by dragging it?

Drag to where?

I might learn a new trick here<g


Gord


On Wed, 30 Nov 2005 16:35:02 -0800, "Amste"
wrote:

by dragging them


"Richard9278" wrote:


How are you hiding the columns?


--
Richard9278
------------------------------------------------------------------------
Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770
View this thread: http://www.excelforum.com/showthread...hreadid=489581

Hidden columns
 

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

Now I know.

Thanks, Gord

On Fri, 2 Dec 2005 14:22:02 -0800, "Amste"
wrote:

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.


"Gord Dibben" wrote:

Amste

How do you hide a column by dragging it?

Drag to where?

I might learn a new trick here<g


Gord


On Wed, 30 Nov 2005 16:35:02 -0800, "Amste"
wrote:

by dragging them


"Richard9278" wrote:


How are you hiding the columns?


--
Richard9278
------------------------------------------------------------------------
Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770
View this thread: http://www.excelforum.com/showthread...hreadid=489581