If you work daily with Word, Excel, or Outlook, you've probably wondered more than once how to make your computer help you type faster, avoiding the need to repeat the same texts or email addresses. That's essentially what you achieve when you know how to activate and control autocomplete in Office : less typing, fewer errors, and a much more efficient workflow.
The problem is that each Microsoft Office application handles autofill differently. When something goes wrong, it feels like "everything's broken." This guide will show you, in detail, how to enable autofill, how to configure it, how to fix it when it's not working, and even how to recover your data list on a new computer.
What exactly is autocomplete in Office and what is it used for?
Microsoft Office includes different autocomplete systems depending on the application and context. Excel suggesting functions when you type a formula is not the same as Outlook completing email addresses, or a text box in a form remembering what someone typed previously.
- In forms and text boxes, autocomplete saves the entries that the user has previously typed. So, when the user types the first few characters again, a drop-down list of possible matches appears. The user can choose a suggestion or ignore it and continue typing normally.
- In Excel, the AutoComplete feature is combined with the fill handle to extend series of numbers, dates, days of the week, months, repeating text patterns, etc. There is also a Formula autocomplete menu that suggests functions, named ranges, and arguments as you create a formula.
- In Outlook, the so-called "Autocomplete list" stores email addresses that you have already written to or from which you have received emails.It automatically suggests them in the To, CC, and BCC fields as you type. It's a separate contact list, based on what you actually use on a daily basis.
Autocomplete in text boxes and forms in Office
In many forms designed with Office tools (for example, templates with text boxes) , the autocomplete function is usually enabled by default. This means that if a user has already entered "8:00" in a particular time field, typing "8" again will suggest that option for them to select without having to type it out again.
This feature is controlled at the text box level. The form designer decides which fields allow the user to receive suggestions based on typing history, and which ones do not. This is very useful when dealing with sensitive information or when it's important to avoid errors caused by reusing old data.
If you want to enable or disable autocomplete for a specific text box in this type of form, the standard procedure is very similar in the different versions of Office that support it:
- Right-click on the text box where you want to change the autocomplete behavior.
- Select the “Text box properties” option (or similar, depending on the specific version of Office).
- In the tab or section related to the presentation or appearance From the control, locate the box “Enable Autocomplete”.
- Check the box If you want the chart to remember and suggest previous values, or turn it off if you need it to always be blank and without suggestions.
This flexibility is very practical when designing templates that will be filled out many times : fields such as company name, city, typical hours, etc., benefit from auto-fill; however, for unique identification numbers or very specific data you may prefer not to use it to avoid confusion.
How to enable formula autocomplete in Excel
Excel has an AutoComplete mechanism specifically designed for formulas, functions, and named ranges , which helps you type faster and reduces syntax errors (missing parentheses, misspelled function names, incorrect ranges, etc.).
As you type a formula, a small pop-up menu appears with suggestions based on what you've already typed. If you start typing "=SUM…", you'll see functions like SUM, SUMIF, SUMIFS, etc. in the list, and you can select the one you need to insert it directly.
In Excel for Mac, you can easily configure this behavior from the application menu :
- Open Excel and go to the “Excel” menu in the top bar, next to the apple icon.
- Select “Preferences” to open the general settings panel.
- Within Preferences, look for the section “Formulas and Lists” and enter the option "Autocomplete".
- Check the box “Show Autocomplete options for named functions and ranges” so that Excel displays the suggestions menu while you type your formulas.
In addition to turning it on or off, Excel lets you decide how many letters you want the AutoComplete menu to appear after . This is useful if you're bothered by it opening too soon or if you work with a lot of custom functions.
Autocomplete in Excel: Fill data with the fill handle
Beyond formulas, Excel (and compatible suites like ONLYOFFICE) incorporates a powerful data auto-completion system through the fill handle , that small square located in the lower right corner of the selected cell.
This function analyzes the initial values you enter and tries to deduce a pattern : it can be a simple repetition of the same text, a numerical sequence, a progression with a fixed jump, a calendar of dates, the days of the week, the months of the year, and even more complex patterns when you provide enough examples.
To copy text into multiple cells using AutoComplete with the fill handle , the idea is very simple:
- Open the file in your spreadsheet editor (Excel or ONLYOFFICE).
- Select the cell or range that contains the text you want to repeat.
- Place the mouse over the fill handle from the bottom right corner until the cursor turns into a small black cross.
- Drag vertically or horizontally to cover the cells where you want to copy that same value.
When you release the mouse button, the selected cells are immediately filled with the original text , saving you from having to copy and paste over and over again when you have entire columns with the same content.
Numbers, dates, coins…
With numbers, dates, times, or monetary amounts, AutoFill becomes even more interesting because it not only repeats the value but can also recognize sequences. For example, if you enter "1" in one cell and "2" in the next, and drag the fill handle, you'll get 3, 4, 5, and so on.
The system recognizes patterns with consistent differences between numbers : if you type 1, 4, 7 and drag, Excel will generate 10, 13, 16… respecting that 3-unit gap. This also applies to dates (each day, each week, each month) and other time series.
Another very common example is the days of the week and months . Since recent versions, editors like ONLYOFFICE can automatically populate a series with Monday, Tuesday, Wednesday… or with January, February, March… starting with the element you choose. Simply type a month or a day, drag the handle, and the rest will be filled in automatically.
An added advantage is that abbreviations are also recognized : you can use "lun" instead of "monday" or "ene" instead of "January", and the autocompleted sequence will follow the correct order.
Rows and columns
Autocomplete works in both columns and rows . In typical examples, we usually fill downwards (vertically), but dragging from left to right to generate horizontal sequences is equally valid; the mechanism is the same, only the direction changes.
Furthermore, Excel and ONLYOFFICE allow you to work with ranges that span multiple rows and columns at once . If you select a block of data with several employees and their vacation days, for example, you can drag the fill handle and copy that pattern to another part of the table without having to duplicate it row by row.
In columns with few distinct text values, another very convenient option is "Select from drop-down list" . If a cell contains, for example, "Yellow" and you want to replace it with "Blue", simply:
- Right-click on the cell with the current value.
- Choose the option “Select from the drop-down list”.
- Choose the desired value (for example, Blue) from among those already existing in that column.
This same approach works for filling empty cells : you select both those with data and those without, drag the fill handle, and the system extends the values following the pattern it detects.
Text Autocomplete Plugin in ONLYOFFICE
In the ONLYOFFICE ecosystem there is a specific plugin called "Autocomplete" that acts as a writing assistant and suggests complete words as you type, very useful when handling large volumes of text or terms that are constantly repeated.
As you type letters into a cell, the plugin suggests all the words that contain that sequence , and you simply click on the one you want to insert it without having to type it all. For example, if you type "Mond," it suggests "Monday," "MondayReport," etc., depending on the content in the sheet or data set.
This not only speeds up writing, but also reduces spelling mistakes , because you tend to choose the correct word from a list instead of typing it from scratch each time.
This add-on is not activated by default , so if you use ONLYOFFICE, you have to install it manually from the plugin manager integrated into the Extensions tab:
- open the tab Extensions in the ONLYOFFICE Spreadsheet Editor.
- Enter in the Plugin manager and look for “Autocomplete”.
- Click on “Install” to add it to your environment.
The Autocomplete plugin is a system plugin, meaning it doesn't display its own icon in the ribbon . Once installed, it remains active until you remove it. To do this, simply return to the plugin manager and click "Remove" next to its name.
If you often work in the browser or with the ONLYOFFICE desktop application , this type of add-on can make a noticeable difference in repetitive tasks such as filling out reports, questionnaires, or extensive lists of descriptions.
Address autocomplete in Outlook: how it works and what it's used for
Outlook's Autocomplete feature is probably one of the most appreciated by those who send many emails a day , because it eliminates the need to type full addresses each time, especially when they are long or unintuitive.
When you start typing in the To, CC, or BCC fields , Outlook checks an internal list of addresses it has accumulated over time (the so-called AutoComplete list ) and shows you suggestions that match the letters you type. This list is populated by recipients you've sent messages to and contacts who have written to you and whom you've used previously.
In professional settings, losing this list when switching computers or formatting your machine can be very frustrating , as you're used to selecting addresses almost automatically. That's why it's important to know both how to activate the option and how to export and recover this autofill file on a new computer.
Check if Outlook AutoComplete is enabled
If you notice that Outlook has stopped suggesting addresses or that no options ever appear when typing in To, CC, or BCC, the first thing to check is whether the Autofill setting is enabled in the application options.
To do this, in Outlook 2016/2019/365 on Windows you can check the following :
- Open Outlook and go to File > Options.
- In the Options window, go to the section "Mail".
- Scroll down to the “Send messages” section, where several boxes related to shipping appear.
- Make sure the option is selected “Use the AutoComplete list to suggest names when typing in the To, CC, and BCC lines”.
- Also check that the box “Automatic name verification” It is activated, since both options usually go hand in hand for proper functioning.
If the AutoComplete list option was unchecked, check it and save the changes by clicking OK . From then on, Outlook will start building a new list as you send emails to different recipients.
What to do when Outlook AutoComplete stops working or becomes corrupted
Sometimes the Autocomplete list malfunctions or stops updating correctly : it may only work during one session and the suggestions are lost when Outlook is closed, or it may stop storing new addresses even though you send them without any problem.
In these cases, it's advisable to reset the AutoComplete cache to force Outlook to create a new, clean file. There are several methods to achieve this, with varying levels of "aggressiveness."
OPTION 1: Empty the list from within Outlook's own options
- Close Outlook completely and reopen it. to ensure that no processes are left hanging.
- Go to File > Options > Mail and scroll down to the “Send messages” section.
- Press the “Clear Autocomplete List” button.
- Confirm in the dialog box that will appear to delete the current content.
Outlook will automatically generate a new cache from the emails you send from that point on.
OPTION 2: Use a special parameter when starting Outlook that clears the AutoComplete cache
To do this you can:
- Close Outlook completely.
- Go to Start > Run (or use the Windows + R key combination).
- Write the command Outlook.exe /CleanAutoCompleteCache and press OK.
With this setting, Outlook starts up, clears the autofill cache, and creates a new file . Again, your address list is reset to zero, but this ensures that any internal corruption is eliminated.
OPTION 3: Manually delete the cache file
The typical procedure is:
- Close Outlook completely.
- Locate the cache folder, usually in C:\Users\ \AppData\Local\Microsoft\Outlook\RoamCache.
- Search for a file with a name of the type “Stream_Autocomplete_X_XXXXX.dat” and delete it.
- Run the Inbox Repair Tool (scanpst.exe) Check your profile's .pst file to correct any data errors.
- Reopen Outlook, go to File > Options > Mail, press again on “Empty Autocomplete list” and send a test message to a new recipient.
- Close Outlook and reopen it, and check if a new “Stream_Autocomplete…” file has been created in the RoamCache folder and if new addresses are starting to be suggested correctly.
The whole process aims to rebuild a fully functional Autocomplete list from scratch , eliminating remnants of corrupted caches that could prevent new addresses from being saved or displayed.
Retrieve or migrate your Outlook Autofill list to another computer
When you switch computers or have to format your current one, the AutoFill list isn't always migrated automatically . If you don't copy it, you'll find that Outlook no longer remembers your usual addresses when you open it on the new computer. The file that stores this list depends on the version of Outlook you have installed, so the first step is always to find out which version you're using.
For Outlook Express and versions 2003/2007
The list is stored in a file with the .nk2 extension . In Windows 7 and 8, the typical path would be:
- C:\Users\your_user\AppData\Roaming\Microsoft\Outlook
Inside that folder, you'll find a file named Outlook.nk2 or with your profile name (for example, events.nk2). That's the file you need to copy and transfer to your new computer to preserve your AutoFill list.
For Outlook 2010 and 2013 (and later)
The system changed from the .nk2 format to Stream_Autocomplete cache files , which are normally stored in:
- C:\Users\your_user\AppData\Local\Microsoft\Outlook\RoamCache
In that folder you will see one or more files whose name begins with “Stream_Autocomplete_”.
To migrate this list to another computer where you already have Outlook configured
You can follow a procedure like this:
- First, set up your email account in Outlook on your new computer..
- Go to the same route C:\Users\your_user\AppData\Local\Microsoft\Outlook\RoamCache on the new computer and check the exact name of the Stream_Autocomplete file that was created.
- Copy the Stream_Autocomplete file containing your complete list from the old computer. and paste it into the RoamCache folder of the new computer.
- Change the name of that copied file so that it exactly matches the one in the file that Outlook created on the new computer.
As you can see, autocomplete in Office ranges from small help when typing data in forms or spreadsheets to complex mechanisms that store address lists in Outlook; knowing where to configure it, how to activate it, how to repair it and how to migrate it between computers saves you a lot of time and headaches, and makes the difference between an Office that "helps you on its own" and one where you're always on the wrong track with extra keys and clicks.
