Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell information
How can I create a choice of words with a scroll list.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell information
You can build a drop-down box using Data Validations. Select "Validations"
from the "Data" menu bar, and select Allow "list" rather than "any value". In the Source box type the selection you want to define separated by a comma eg. oranges, apples, bananas. This will give you a drop-down of those three words. You can also link the Source box to a range or a named range. Hope this helps. -- www.plumsolutions.com.au.xxx Specialists in Financial Modelling "bellamy martin" wrote: How can I create a choice of words with a scroll list. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell information
Hi,
Do the following: 1. On the Tools menu, click Options. The Options dialog box displays. 2. Click the Custom Lists Tab. 3. Under "Custom lists" list, click NEW LIST. When you click NEW LIST, The Add button is enabled and the cursor is positioned inside the List entries list. 4. Type item name seperated by comma - As demiliter to seperate values. -or- * Click the import button * Import list from cells * Select the Range of cells from your excel sheet. Important; Before performing this operation, enter cell values to select as cell range for your custom list. 5. Click Add button. 6. Click OK. For example, Now enter any value in your cell ans pull the handle side ways or or below, all values will be populated on the sheet. Challa Prabhu "bellamy martin" wrote: How can I create a choice of words with a scroll list. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining multiple cell information into one cell | Excel Discussion (Misc queries) | |||
cell won't let me put all of information into it. | Excel Discussion (Misc queries) | |||
When copying a cell to another cell the information is duplicated. | Excel Worksheet Functions | |||
Using cell information in formula? | Excel Worksheet Functions | |||
Auto-fill cell based on adjacent cell information.. | Excel Worksheet Functions |