Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting
I'm creating a template with several locked cells and only a few remaining
for data input. Is there a way to mark or highlight the cells that can/need to have data input but does not show on the printed version? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting
You could use background colors in the data entry cells as long as you set
your print setting to black and white printing. Click FILE in the menu and select PAGE SETUP. Click the SHEET tab and in the center of the dialog box, in the PRINT panel, click the checkbox named BLACK AND WHITE. Hope this helps. -- Kevin Backmann "Jane N" wrote: I'm creating a template with several locked cells and only a few remaining for data input. Is there a way to mark or highlight the cells that can/need to have data input but does not show on the printed version? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) |