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?

fixer1234
  • 27,064
  • 61
  • 75
  • 116
Gillian van Niekerk
  • 1

1 Answers1

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.

JustinStolle
  • 1,455
  • 2
  • 13
  • 20