| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Preventing cell contents from printing
I've got cells in my worksheet that I've changed the font color and
background color the same, so the contents are not visible when viewing the sheet... I don't want the contents of these cells to be printed either... Is there a way to prevent them from printing? |
|
#2
|
|||
|
|||
|
Depending on the specific printer and the color you chose to use, try:
<File <PageSetup <Sheet tab, And *UNCHECK* "Black & White". -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Blair Scanlan" <Blair wrote in message ... I've got cells in my worksheet that I've changed the font color and background color the same, so the contents are not visible when viewing the sheet... I don't want the contents of these cells to be printed either... Is there a way to prevent them from printing? |
|
#3
|
|||
|
|||
|
I've already tried that unsuccessfully...
"Ragdyer" wrote: Depending on the specific printer and the color you chose to use, try: <File <PageSetup <Sheet tab, And *UNCHECK* "Black & White". -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Blair Scanlan" <Blair wrote in message ... I've got cells in my worksheet that I've changed the font color and background color the same, so the contents are not visible when viewing the sheet... I don't want the contents of these cells to be printed either... Is there a way to prevent them from printing? |
|
#4
|
|||
|
|||
|
Can you hide the rows/columns?
-- Don Guillett SalesAid Software "Blair Scanlan" <Blair wrote in message ... I've got cells in my worksheet that I've changed the font color and background color the same, so the contents are not visible when viewing the sheet... I don't want the contents of these cells to be printed either... Is there a way to prevent them from printing? |
|
#6
|
|||
|
|||
|
You could use conditional formatting to change the font to white, when
printing. There's an example he http://www.contextures.com/xlCondFormat03.html#Print Blair Scanlan wrote: I've already tried that unsuccessfully... "Ragdyer" wrote: Depending on the specific printer and the color you chose to use, try: <File <PageSetup <Sheet tab, And *UNCHECK* "Black & White". -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Blair Scanlan" <Blair wrote in message ... I've got cells in my worksheet that I've changed the font color and background color the same, so the contents are not visible when viewing the sheet... I don't want the contents of these cells to be printed either... Is there a way to prevent them from printing? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
| How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
| Display actual contents of cell | Excel Discussion (Misc queries) | |||
| How do I automatically rename a sheet with the contents of a cell. | Excel Discussion (Misc queries) | |||
Linear Mode
