Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight or change fonts for input purposes only/not printing.
Many of the spreadsheets I use require updating over time. I want to
distinguish the areas that require user input from those that are text or formula-driven without having them print differently. I send out reports to clients and do not want the font changes or highlighting to show. Normally, I put User-Input areas in a dark-blue font, and leave the rest as automatic, however this comes out slightly differently when printed. Can anyone offer other suggestions? -- DianeB |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight or change fonts for input purposes only/not printing.
Hi Diane
What happens if you print in Grayscale? Also, my printer has an option in the "Advance" area of the printer dialog box to use the black cartridge only. Possibly these would solve the problem if the options are available to you? -- OneFineDay "DianeB" wrote: Many of the spreadsheets I use require updating over time. I want to distinguish the areas that require user input from those that are text or formula-driven without having them print differently. I send out reports to clients and do not want the font changes or highlighting to show. Normally, I put User-Input areas in a dark-blue font, and leave the rest as automatic, however this comes out slightly differently when printed. Can anyone offer other suggestions? -- DianeB |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight or change fonts for input purposes only/not printing
Thank you, M. I also discovered a posting dated 8/31/06 wherein someone was
trying to print in white background and black font even though they had changed the display on excel to be blue with white print. The response from Gord Dibeen said to try: FilePage SetupSheet, and Checkmark in "Black & White". I tried that and it works even when I highlight a cell in yellow. Yipee! It would be nice if Excel allowed us to set "internal" fonts/highlighting (to alert Users to examine or input to those cells, but that wouldn't print at all, even if we wanted to print in color. -- DianeB "M Thompson" wrote: Hi Diane What happens if you print in Grayscale? Also, my printer has an option in the "Advance" area of the printer dialog box to use the black cartridge only. Possibly these would solve the problem if the options are available to you? -- OneFineDay "DianeB" wrote: Many of the spreadsheets I use require updating over time. I want to distinguish the areas that require user input from those that are text or formula-driven without having them print differently. I send out reports to clients and do not want the font changes or highlighting to show. Normally, I put User-Input areas in a dark-blue font, and leave the rest as automatic, however this comes out slightly differently when printed. Can anyone offer other suggestions? -- DianeB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't change default fonts | Excel Discussion (Misc queries) | |||
Read Input file and highlight matches in excel | Excel Discussion (Misc queries) | |||
Why is my printer printing white fonts as black? | Excel Worksheet Functions | |||
is there a way to change formulas to values for sorting purposes? | Excel Worksheet Functions | |||
Can I auto number, serialize a spreadsheet for printing purposes. | Excel Discussion (Misc queries) |