Hi,

That behavior exists in design are of PivotTables but not for quite the
purpose you are refering to. Direction appear that say Drop Row Fields Here
and when you drop a field in that area the message disappears.

But there is no such feature available to the Excel user for this purpose.
However, you could enter instructions in cells and when the user typed on
those cells the instructions would be replaced. But then, that is just
Excel's default behavior.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Ron" wrote:

I believe I've seen Excel fill in forms that has the instruction of what to
put in a cell written in the cell in maybe a shadowed-type print. Then as
one uses the form and begins to enter information in that particular cell the
instruction disappears and the newly typed information replaces it. What is
that called in Excel and how is it done?
--
Farmer Ron