Place holder text

C

Candace

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?
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top