| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I get to data in drop down lists in Excel by pressing lett
I want to know how to automate drop down lists in excel, so that data entry
staff can type in the letter and the option appears, without necessarily opening the drop down list. I have seen spreadsheets designed in such a way that when staff place their cursor over the cell a little hand appears similar to either html or access. All help gratefully received. |
|
#2
|
|||
|
|||
|
You could check out DataValidation...List or check that
Toolsoptions...EditEnable autocomplete for cell values is checked -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Dmafk" wrote in message ... I want to know how to automate drop down lists in excel, so that data entry staff can type in the letter and the option appears, without necessarily opening the drop down list. I have seen spreadsheets designed in such a way that when staff place their cursor over the cell a little hand appears similar to either html or access. All help gratefully received. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Linking the data from one excel to another | Excel Discussion (Misc queries) | |||
| Update Excel Data List for Drop Down use | Excel Discussion (Misc queries) | |||
| Importing xml Data into Excel 2002 | Excel Discussion (Misc queries) | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
