printing...

[just1creation]

is it possible to print certain columns only? example: columns A,B,C,D,E... but when click print, i only want columns B,D, and E to be visible on paper. i know i can highlight the columns to be printed but that is not what i want. just click print and wam!

thanks...

[Dave Peterson]

Record a macro when you hide the columns you don't want to print. Then print
the worksheet. Then unhide those columns. And stop recording.

Now you can just re-run that macro when you want to print your stuff.



just1creation wrote:
>
> is it possible to print certain columns only? example: columns
> A,B,C,D,E... but when click print, i only want columns B,D, and E to be
> visible on paper. i know i can highlight the columns to be printed but
> that is not what i want. just click print and wam!
>
> thanks...
>
> --
> just1creation
> ------------------------------------------------------------------------
> just1creation's Profile: http://www.excelforum.com/member.php...o&userid=35468
> View this thread: http://www.excelforum.com/showthread...hreadid=562948

--

Dave Peterson

[CLR]

You would have to employ a macro, to hide or move the columns not desired to
be printed, then set the print area and print, then restore things back to
normal.

Vaya con Dios,
Chuck, CABGx3



"just1creation" wrote:

>
> is it possible to print certain columns only? example: columns
> A,B,C,D,E... but when click print, i only want columns B,D, and E to be
> visible on paper. i know i can highlight the columns to be printed but
> that is not what i want. just click print and wam!
>
> thanks...
>
>
> --
> just1creation
> ------------------------------------------------------------------------
> just1creation's Profile: http://www.excelforum.com/member.php...o&userid=35468
> View this thread: http://www.excelforum.com/showthread...hreadid=562948
>
>