Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You could add a cell Comment that would flyout when the user hovers over the
cell. You could color the cell for user's attention using Conditional Formatting so when blank it would be colored and after typing the age, it would lose the color. Gord Dibben MS Excel MVP On Fri, 26 Sep 2008 10:43:01 -0700, 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I delete an instruction box? | Excel Worksheet Functions | |||
Adding a cell instruction for the user | Excel Discussion (Misc queries) | |||
How do I make an important instruction cell flash in Excel? | Excel Discussion (Misc queries) | |||
template for works instruction | New Users to Excel | |||
excel97 vs excel2000 (Find instruction) | New Users to Excel |