| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Make a cell content not printable
I want some cell contents of my worksheet not to be printed.
I have resolved my problem by running a small macro before printing but I think it would be much better to have a function within excel, similar to the one for the other objects where you can select or not the "Print object" from properties. Can anybody help?? -- Basilio |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Make a cell content not printable
Use Conditional Formatting with the FormulaIs option. Pick a cell like Z100.
Set the condtional format of the cell you wish to avoid printing to say that if Z100 is not empty, then make the font color the same as the background color. Repeat for each cell you wish to avoid printing. -- Gary''s Student - gsnu200909 "basilio" wrote: I want some cell contents of my worksheet not to be printed. I have resolved my problem by running a small macro before printing but I think it would be much better to have a function within excel, similar to the one for the other objects where you can select or not the "Print object" from properties. Can anybody help?? -- Basilio |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make charts printable in a worksheet in Excel 2007? | Charts and Charting in Excel | |||
| Make a printable version of the Excel formula help page. | Excel Worksheet Functions | |||
| How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
| how to make cell content to flash | Excel Discussion (Misc queries) | |||
| How can I make the bar that shows the content of the cell visible. | Excel Discussion (Misc queries) | |||
Linear Mode
