I there a way to not print a cell(s)?

[Guest]

I am trying to fiqure out if there is a way to not print cells?

 

[Anne Troy]

--Set a print area that doesn't include those cells.
--Temporarily change the font to match the cell fill color.
Generally, when I need a setup like this, I place those cells outside the
"regular" area of the page, and set the print area not to include it.
************
Anne Troy
www.OfficeArticles.com

 

[Guest]

Set a print area that doesn't include those cells.<<

But when you do that it counts each area as its own page how do you get it
to prin on one page only????

 

[nick]

I would also like to know, is there no way of just not printing a few cells,
I think that I have tried everything, but setting print areas do not work.
Is there really no way so information is accessible on the computer screen
but not when printed?

 

[Don Guillett]

hide the rows/columns desired>print>unhide

 

[Gord Dibben]

Very difficult to print non-contiguous areas of a sheet.

You can hide entire rows and columns but to hide individual cells you must
change the font color to same as background color.

Or copy/paste non-contiguous areas to a single contiguous range.


Gord Dibben MS Excel MVP