Excel 2013 has an AutoComplete option that can be turned on or off depending on individual user preference. So if you use Excel 2013 on another computer and find AutoComplete to be helpful, or if you simply want to see if you like it, then you may be looking for a way to enable AutoComplete in your version of Excel 2013.
Our guide below will direct you to the location on the Excel Options menu where the AutoComplete setting is located so that you can turn it on or off as needed.
Enabling AutoComplete in Excel 2013
The steps in this guide will assume that AutoComplete is currently turned off for your Excel 2013 installation, and that you wish to turn it back on. Once AutoComplete is turned on, Excel will prompt you with options that you can enter into the active cell, based on what you have already typed. For example, typing the letter “j” in the picture below prompts me to complete the word with the letters “oe” because I had previously typed the word “joe” into my sheet.
Here is how to enable AutoComplete in Excel 2013 –
- Open Excel 2013.
- Click the File tab at the top-left corner of the window.
- Click Options at the bottom of the column at the left side of the window.
- Click Advanced in the left column of the Excel Options window.
- Check the box to the left of Enable AutoComplete for cell values, then click the OK button to apply your changes.
These steps are also shown below with pictures –
Step 1: Open Excel 2013.
Step 2: Click the File tab.
Step 3: Click Options in the column at the left side of the window, which opens the Excel Options window.
Step 4: Click the Advanced tab in the Excel Options window.
Step 5: Check the box to the left of Enable AutoComplete for cell values so that there is a check mark in the box, then click the OK button at the bottom of the window.
There is also an option called Flash Fill that you can enable here as well. It will attempt to sense patterns in the data that you are entering, and will offer to complete a series of data to save you time. This video can explain more about Flash Fill and show it in action.
Do you have an Excel worksheet that has a lot of unwanted or incorrect formatting? Learn how to remove all cell formatting in Excel 2013 so that you can start over with untouched data.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.