Non-Printing Cells

  • Thread starter Andrew Mackenzie
  • Start date
A

Andrew Mackenzie

Can anyone tell me whether it is possible to format individual cells so that
they do not print. I do not want to hide rows or columns as I want to be
able to see the contents on the screen.

Thanks
 
J

Jim Cone

Andrew,

Almost what you want...
Use a custom number format of 3 semicolons ;;;
The content of the cell will appear in the formula bar but not on the screen.

Regards,
Jim Cone
San Francisco, CA
 
G

Gord Dibben

Andrew

Excel has no "do not print this cell" feature.

You could color the cells' font to white.

You could format the cells as Custom ;;;

Have you tried using View>Custom Views whereby you can set up a couple of
different views, one for viewing and one for printing?

Then there is VBA. You could code a BeforePrint routine that would hide rows
and columns at time of printing.

Gord Dibben Excel MVP
 
Top