Automatic cell suggestions

[srl]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I just switched from Excel for Windows to Excel for Mac. In the Windows version, if you were entering text into a cell and there was text in a previous entry in that column that matched what you were typing, Excel would fill in the cell with the previous entry. You could stop typing to accept the suggestion or continue typing if that was not the text you were entering.

In the Mac version, instead of filling in the cell, a drop down box appears with choice(s) for the cell. If there is a match, you don't have to continue typing but you do have to choose the match, I assume with the mouse. I know it's a small issue, but going from the keyboard to the mouse to select the entry and then back to the keyboard to continue typing is somewhat disruptive.

Is there any way to change this behavior in Excel Mac?

Thanks.

 

[Shane Devenshire]

Hi,

Although not as easy as tab, you can press down arrow Enter, up arrow Enter,
End Enter, or Home Enter and still keep your hands on the keyboard.

 

[srl]

Thanks. I'm glad there is some way to do this other than with the mouse; this is much easier.

Sheri

 

[CyberTaz]

Just a tweak to Shane's suggestion: If you press the return key the cell
selector will move one row lower in the sheet as usual. If you want to
continue along the same row (without having to navigate back to it) press
the Tab key rather than Enter/return after arrowing to your choice.

HTH |:>)
Bob Jones
[MVP] Office:Mac