Auto suggest entries?

[Manju]

Is it possible by Excel 2003 to suggest possible entries when we start
filling a cell. I am ready to have a column of possible entries in the
same sheet. What I would like is to have excel suggest entries based on
first few letters we type. I have seen this working only if the data is
in the SAME column.
Regards

 

[Gord Dibben]

You are correct.

Tools>Options>Edit>Enable Autocomplete works only in the same column.

To get AC in any cell you will have to use Data Validation using a combo-box.

See Debra Dalgleish's site for method and instructions.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

 

[Manju]

Many Thanks.
The basic need of the request was to avoid using mouse. I knew about
the validation tool (but not combobox), but it requies the use of mouse
to clkick the drop down list. Is there a way to avoid double clicking
to activate combobox? Or at least give me a keyboard shortcut for
double click. I tried F2, it doesn't work. Thanks for the help.

Regards
Manju

 

[Manju]

Excellent. That's EXACTLY what I needed. a keyboard shortcut.

I love my keyboard
Many Thanks

I'm not sure if you can work this into whatever solution you select, but

When you're on a dropdown list, combo box, or cell with autocomplete options
If you hold down [Alt] and press the down arrow...you'll see the list.
Then you can arrow down/up to the item you want and press [enter]

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

Is it possible by Excel 2003 to suggest possible entries when we start
filling a cell. I am ready to have a column of possible entries in the
same sheet. What I would like is to have excel suggest entries based on
first few letters we type. I have seen this working only if the data is
in the SAME column.
Regards