printing...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

just1creation - 19 Jul 2006 17:42 GMT

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

Signature

just1creation

Reply to this Message

Dave Peterson - 19 Jul 2006 18:02 GMT

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.

> 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
[quoted text clipped - 8 lines]
> just1creation's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35468
> View this thread: http://www.excelforum.com/showthread.php?threadid=562948

Signature

Dave Peterson

Reply to this Message

CLR - 19 Jul 2006 18:10 GMT

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

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

Reply to this Message