Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pull-down text in a cell
How do I create a cell with a pull-down arrow to select a value from a list? -- MrSeagull ------------------------------------------------------------------------ MrSeagull's Profile: http://www.excelforum.com/member.php...o&userid=27722 View this thread: http://www.excelforum.com/showthread...hreadid=472367 |
#2
|
|||
|
|||
Use Vaidation from the Data Menu. Choose the option for List from the Allow:
drop-down. Type the values you want in the line provided, separating each value with a comma (for US settings). Alternatively, you can type your list in a range of cells on your spreadsheet. -- tj "MrSeagull" wrote: How do I create a cell with a pull-down arrow to select a value from a list? -- MrSeagull ------------------------------------------------------------------------ MrSeagull's Profile: http://www.excelforum.com/member.php...o&userid=27722 View this thread: http://www.excelforum.com/showthread...hreadid=472367 |
#3
|
|||
|
|||
Great, thanks alot! -- MrSeagull ------------------------------------------------------------------------ MrSeagull's Profile: http://www.excelforum.com/member.php...o&userid=27722 View this thread: http://www.excelforum.com/showthread...hreadid=472367 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not all of the text is visible when looking at the cell. | Excel Discussion (Misc queries) | |||
Why doesn't text wrap in a cell in Excel? | Excel Discussion (Misc queries) | |||
Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
Moving text from one cell to another. | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |