0

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?

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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.