Place holder text

  • Thread starter Thread starter Candace
  • Start date Start date
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?
 
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

Similar Threads

"Place holders" 1
Tax disc holder 6
hiding place holders 3
What I believe is a Watermark 4
How can I set some cells to not print w/o changing print layout? 1
Excel EXCEL 2010 HELP 1
Greying out text 2
Text colors and printing 1

Back
Top