| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NOT Printing certain cells within the print range
I have a worksheet that has certain cells that I want to see while working
within the spreadsheet. However, I do NOT want anthing that is in those specific cells to print? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NOT Printing certain cells within the print range
I use Conditional Formatting for this purpose. Set the Conditional Format of
the cells to something like: Formula is =$A$10 and then set the font to white if the background is white. So if you set A1 to 0 all the cells are visible, set A1 to 2 and the "secret" cells appear empty and you are ready for printing. -- Gary''s Student - gsnu200716 "Daniel R" wrote: I have a worksheet that has certain cells that I want to see while working within the spreadsheet. However, I do NOT want anthing that is in those specific cells to print? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel printing cannot print landscape | Setting up and Configuration of Excel | |||
| Print Blank Pgs - Preview margins outside print range | Excel Discussion (Misc queries) | |||
| how do I print a range without printing the blank pages? | Excel Discussion (Misc queries) | |||
| Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
Hybrid Mode
