Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Data validation solves my need. But it is not a quick, easy way. Is there improvement possiblities, some easier alternatives ? I have Data Validation List for example Master Mike H. Master Eduardo ...... ...... And assume the list has 1000 items [although to have so much so good masters is not possible : ) ] It is difficult to press data validation arrow, scroll down many times and find the needed item. When I start writing Master M in a data validation applied cell, is it possible to see the list of all alternatives automatically. (And to click if poosible.) Any alternatives better than "click validation list arrow, see list, scroll downs, try to see little letters" would be better option for me. By the way, I apologize for the humour above (items of the sample validation list) , and I would be very pleased if anyone would tell me if such humours are not welcomed in the group. Best regards, Cousin Excel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Typing HTE automatically changes to THE and I don't want to | Excel Discussion (Misc queries) | |||
How to have cells automatically expand when typing | Excel Discussion (Misc queries) | |||
HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN. | Excel Discussion (Misc queries) | |||
How do I enter a decimal automatically without typing it every ti. | New Users to Excel | |||
How can I automatically have 10% added to cell after typing a valu | Excel Worksheet Functions |