Excel's autofill feature can suggest usernames you've typed before, but you control what gets saved and when
When you type a username in an Excel cell and press Enter, Excel remembers it. The next time you start typing the same letters in any cell in that workbook, Excel will suggest the full username you typed before. This is autofill — it saves you from retyping the same entries over and over. You don't need to turn it on or configure it. It works automatically as long as you haven't disabled it in your settings.
The catch is that autofill only suggests entries you've already typed in that same column, and only if you're using the same workbook. If you close the file and reopen it, the suggestions are still there. But if you delete a username from the column, Excel stops suggesting it.
Key Takeaways
- Autofill suggestions appear automatically when you type in a cell, based on entries you've already typed in that column.
- Press Tab or Enter to accept an autofill suggestion, or keep typing to ignore it and enter something different.
- You can clear autofill history by deleting the entries from the column, but this removes them from the workbook permanently.
- Autofill works within a single workbook and does not sync across different Excel files or devices.
How autofill suggestions appear when you type
Start typing a username in any cell. As soon as Excel recognizes the first letter or two, it will show a suggestion in gray text inside the cell. This gray text is the full username that matches what you're typing. If that's the username you want, press Tab or Enter to accept it. The gray suggestion becomes solid text and fills the cell.
If the suggestion is not what you want, keep typing. The suggestion will change as you add more letters, or disappear if you type something that doesn't match any previous entry. When you finish typing what you actually want, press Enter or Tab, and that new entry gets saved for future autofill suggestions.
Where Excel stores autofill suggestions
Excel stores autofill suggestions in the workbook file itself, not on your computer or in the cloud. This means the suggestions only appear when you open that specific file. If you email the workbook to someone else, they will see the same autofill suggestions you do — because the suggestions are part of the file.
If you want to keep autofill suggestions private or remove them before sharing a file, you need to delete those entries from the column. There is no separate list to edit; the autofill memory is built from the actual data in the cells.
Turning autofill on or off
Autofill is on by default in Excel. If you find that suggestions are not appearing, autofill may have been turned off. To turn it back on, go to File > Options > Advanced. Scroll down to the Editing options section and check the box next to Enable AutoComplete for cell values. Click OK.
If you want to turn autofill off entirely, uncheck that same box. When autofill is off, Excel will not suggest previous entries as you type, and you will have to type every username in full each time.
Clearing autofill history from a column
There is no button to clear autofill suggestions without deleting the data. If you want to remove a username from the autofill list, you must delete it from the cells where it appears. Select the cell containing the username you want to remove and press Delete. The entry disappears from the column and will no longer appear as an autofill suggestion.
If you want to clear all autofill suggestions from a column, delete all the entries in that column. This is permanent — once you save the file, those suggestions are gone. You cannot undo this after closing and reopening the workbook.
Using autofill with data validation lists
If you have set up a data validation list in Excel — a dropdown menu of approved usernames — autofill works alongside it. When you click the cell, you see the dropdown arrow. When you start typing, autofill suggestions appear. You can either click a username from the dropdown or type to trigger autofill. Both methods work together.
Data validation lists are more reliable than autofill if you need to enforce a specific set of usernames. Autofill will suggest anything that has ever been typed in that column, even if it was a typo. A validation list only allows the usernames you explicitly add to it.
Why autofill suggestions sometimes don't appear
Autofill only works within the same column of the same workbook. If you type a username in column A and later try to type it in column B, autofill will not suggest it — it only remembers entries from column B when you're working in column B. This is by design and cannot be changed.
Autofill also does not work across different Excel files. If you type a username in one workbook and then open a different workbook, the new file will not have that username in its autofill memory. Each file keeps its own history.
Frequently Asked Questions
Can I copy autofill suggestions to a different workbook?
No. Autofill suggestions are stored in the workbook file itself and do not transfer. If you need the same usernames in a new file, copy the cells containing those usernames and paste them into the new workbook. Then autofill will work with those entries in the new file.
Does autofill work on shared Excel files or OneDrive?
Autofill suggestions are stored locally in your copy of the file. If you and a coworker both open the same file from OneDrive, you will each see only the autofill suggestions from entries you have typed yourself, not entries the other person typed. Autofill does not sync across users.
Can I make autofill suggest usernames from a different column?
No. Autofill only suggests entries from the column you are currently typing in. If you need to pull usernames from a different column or sheet, use a dropdown list with data validation instead, or use a VLOOKUP formula to look up usernames from another location.
What happens to autofill suggestions if I sort or filter the data?
Autofill suggestions are not affected by sorting or filtering. Excel remembers every username that has been typed in that column, whether the rows are hidden, sorted, or deleted. The suggestions remain until you manually delete the entries from the cells.