LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default Start typing, possible alternatives appear automatically

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Typing HTE automatically changes to THE and I don't want to Orange&Blue Excel Discussion (Misc queries) 2 February 22nd 10 04:59 PM
How to have cells automatically expand when typing Northwoods Excel Discussion (Misc queries) 3 April 6th 07 07:34 PM
HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN. Trenner Excel Discussion (Misc queries) 2 May 16th 06 12:33 PM
How do I enter a decimal automatically without typing it every ti. Hayley New Users to Excel 4 March 1st 05 01:21 AM
How can I automatically have 10% added to cell after typing a valu cjrolls Excel Worksheet Functions 3 December 13th 04 01:45 PM


All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"