| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I enter more data to an already made pull down menu
I have created a spreadsheet with pull down menus, I have forgotten some
information that needs to be put in the pull down, how to I fix that ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I enter more data to an already made pull down menu
put cursor in the cell with the menu go to Data tab, Validation settings it will tell you where your information is located. go to that area, insert your new info and then make sure you change the cell range in the Data box (Validation window) -- CBrausa ------------------------------------------------------------------------ CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677 View this thread: http://www.excelforum.com/showthread...hreadid=513348 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
|
Data Analysis Options disappears from |
Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| enter data in cell which will start macro to move data to sheet2 | Excel Discussion (Misc queries) | |||
| External Data to be used as in a pull down menu in Excel2003 | Excel Discussion (Misc queries) | |||
| Automatically pull data into another worksheet within the same fil | Excel Worksheet Functions | |||
Hybrid Mode
