Data Validation / Allow List


L

Louise

Hi all

I have used the above function to create a drop-down list in a range of
cells in Excel. Is there any way that, when you click onto the drop-down
arrow, you can quickly get to, for example, items beginning with the letter
's' in the list? I've tried simply pressing the key and it doesn't work.

Is there such a function?

THank you.
Louise
 
Ad

Advertisements

L

L. Howard Kittle

Hi Louise,

Give this a try. Type in the "s" in the data validation cell but DON'T hit
Enter. Now click on the drop down arrow while the cell is still in the edit
mode. Should take you to the top of the s list.

HTH
Regards,
Howard
 
G

Gord Dibben

Nice trick Howard.

A keeper, for sure.

I either never saw before or definitely had forgotten.


Gord
 
L

L. Howard Kittle

Thanks, Gord.

Probably should clarify that there needs to be a single letter at the top of
each letter category of the list. A, B, C etc. C will not take you to the
first item in the "c" list if it is "cat" for instance.

Regards,
Howard
 
Ad

Advertisements

G

Gord Dibben

Point noted.

Thanks Howard

Thanks, Gord.

Probably should clarify that there needs to be a single letter at the top of
each letter category of the list. A, B, C etc. C will not take you to the
first item in the "c" list if it is "cat" for instance.

Regards,
Howard
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top