Hidden columns

[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

[Gord Dibben]

Keep them hidden.

They won't print.


Gord Dibben Excel MVP

On Wed, 30 Nov 2005 12:57:11 -0800, "Amste" <[email protected]>
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

[Amste]

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" <[email protected]>
> 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
>
>

[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

[Richard9278]

How are you hiding the columns?

[Gord Dibben]

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


Gord

On Wed, 30 Nov 2005 13:51:11 -0800, "Amste" <[email protected]>
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" <[email protected]>
>> 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
>>
>>

[Richard9278]

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

Rick

[Amste]

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

[Amste]

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

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

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

[Gord Dibben]

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" <[email protected]>
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
>>
>>

[Amste]

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

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


"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" <[email protected]>
> 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
> >>
> >>
>
>

[Gord Dibben]

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" <[email protected]>
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" <[email protected]>
>> 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
>> >>
>> >>
>>
>>