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

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

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

"K Whitman" wrote in message
...
I am trying to fiqure out if there is a way to not print cells?

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????

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

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?

"Khamul" wrote:

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????

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

hide the rows/columns desiredprintunhide

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"nick" wrote in message
...
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?

"Khamul" wrote:

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????

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

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

On Fri, 5 Mar 2010 15:19:34 -0800, nick
wrote:

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?

"Khamul" wrote:

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????