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. |
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. |
All times are GMT +1. The time now is 12:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com