Create a column that does not print

K

Kelly

I want to have a column that I can see on my screen (it has notes for me),
but that does not print when I print the worksheet. Can i select a column to
not print?
 
K

Kassie

You can create a print area that excludes this column, on the proviso that
said column is at the far right or left of the rest of the sheet. Say your
print range is from A1 to G55, with your notes in column H, or else your
notes in Column A, and your print range from B1 to say H55.

Else you can go for a macro that will hide the column before printing, and
then unhide it again, once the worksheet has been printed.
 
K

Kelly

The column is in the middle and I cant move it, but a macro seems like it
would work. Unfortunately I not familar with Macros or how to write them...
Do you know of any resources out there that I can go to get something or at
least get a little 'educated'
 
G

Gord Dibben

If you hide the column it won't print.

You can do this manually by selecting the column and Format>Column>Hide.

If you want a macro.....................

Turn on the macro recorder at Tools>Macro>Record New Macro.

Hide the column, do your print, unhide the column.

Turn off recorder. Now you have a macro that will do the same thing print
after print.

If you're not familiar with VBA and macros, see David McRitchie's site for
more on "getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

or Ron de De Bruin's site on where to store macros.

http://www.rondebruin.nl/code.htm


Gord Dibben MS Excel MVP
 
Top