Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is it possible to enter place holder text that looks kind of like a
greyed-out watermark? For instance in one cell the user needs to enter the name of a person. But there aren't any titles or field headers on this spreadsheet, because this spreadsheet will be printed on a pre-printed hardcopy that already has the word/title "NAME" printed on it. So I am trying to give the user a clue as to what goes in each field, but I don't want that clue printed out when the document is printed. Any ideas/suggestions on how to accomplish this goal? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Think you could use data validation's input message
Select the cell(s), click Data Validation Input Message tab Type the message in the box eg: Enter name Click OK The message will display when the cell is selected -- Max Singapore http://savefile.com/projects/236895 Downloads:22,000 Files:370 Subscribers:66 xdemechanik --- "Candace" wrote: Is it possible to enter place holder text that looks kind of like a greyed-out watermark? For instance in one cell the user needs to enter the name of a person. But there aren't any titles or field headers on this spreadsheet, because this spreadsheet will be printed on a pre-printed hardcopy that already has the word/title "NAME" printed on it. So I am trying to give the user a clue as to what goes in each field, but I don't want that clue printed out when the document is printed. Any ideas/suggestions on how to accomplish this goal? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
place text in one cell | Excel Worksheet Functions | |||
Place picture behind text | Excel Discussion (Misc queries) | |||
Why am I seeing ###### in place of text within the cell? | Excel Discussion (Misc queries) | |||
How do I print a file holder label from Excel to a dox matrix pri. | Excel Discussion (Misc queries) |