| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 40060 | 2003-11-26 20:37:00 | Printing without shading in Excel | GregD (3099) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 194929 | 2003-11-26 20:37:00 | Have set a form up in Excel and have shaded cells to make filling it in easier, but I don't want the shading to print out. Any ideas? Cheers Greg |
GregD (3099) | ||
| 194930 | 2003-11-26 21:12:00 | Use Yellow as a shading colour. On B&W printers, its usually invisible. |
godfather (25) | ||
| 194931 | 2003-11-27 03:58:00 | As Godfather has suggested yellow shading prints very lightly when printing black and white but try and make it as light a yellow as possible, not the bright yellow shade. About 50% shading normally does the trick for me. | Susan B (19) | ||
| 194932 | 2003-11-27 04:49:00 | Thanks guys - tried that with not much success, so kept looking and hit on it. In page setup on the sheet tab there is an option to print in black & white. Ticked this - and perfect. Cheers Greg |
GregD (3099) | ||
| 1 | |||||