printing...

J

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

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

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
 
Top