View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default how do I display an instruction in a cell?

Two possibilites. One is easy. The other wone takes a bit more work but is
more in line with your exact description. I would go with the easy option.

Easy... You can use data validation. Select the cell in question. Select
Data - Validation - Input Message tab. Add your message. When the cell is
selected the message is displayed. The cell must be selected for this to
work.

Harder... Check out this link...
http://spreadsheetpage.com/index.php...e_camera_tool/
--
HTH...

Jim Thomlinson


"matty" wrote:

I want to display a command or instruction in a cell. for example: in the
cell user sees "enter age" the user clicks on the cell and enters thier age.