How can I select the drop down fill-in text with keyboard in Excel 2008?

Question

I have a spreadsheet of files and when I need to insert new filenames, Excel very handily produces a drop down list of similar entries. Pressing enter autofills, but then I have to click the cell to add in further text. Any way to accept the auto fill and still be active in the cell to type in more?

score 1 · Answer 1 · answered Feb 08 '13 at 21:13

1

Instead of pressing enter, press F2, then either End or Right Arrow and you should be able to continue typing without moving to another cell.

answered Feb 08 '13 at 21:13

JustinStolle

1,564

How can I select the drop down fill-in text with keyboard in Excel 2008?

1 Answers1