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?

Answer 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.