| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list in Excel
I need a drop down to expedite the entry of info. However, I also need the
cell(s) formatted so as to take info not contained in the drop down. How can I accomplish this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list in Excel
Use Data Validation to set your list. On the error alert tab either uncheck
the Show error alert after invalid data is entered box or change the style to warning or info. -- If this helps, please remember to click yes. "BillyBoy" wrote: I need a drop down to expedite the entry of info. However, I also need the cell(s) formatted so as to take info not contained in the drop down. How can I accomplish this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list in Excel
Watch this 5 min video:
How to setup a data validation drop down list: http://youtube.com/watch?v=t2OsWJijrOM To allow manual entries, on the Error Alert tab, uncheck "Show error alert after invalid data is entered". -- Biff Microsoft Excel MVP "BillyBoy" wrote in message ... I need a drop down to expedite the entry of info. However, I also need the cell(s) formatted so as to take info not contained in the drop down. How can I accomplish this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel drop down list | Excel Discussion (Misc queries) | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Linear Mode
