printing cells

[andrewm]

Hi
When I print a sheet there are a few cells which I would like not to
print.
When I highlight the print area without the cells I don't want to
print, it prints out several pages.
How can I print a whole sheet all in one and not print (show blank)
certain cells


andrewm

 

[Debra Dalgleish]

You can use conditional formatting to hide the content of some cells
when printing. There's an example here:

http://www.contextures.com/xlCondFormat03.html