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