How to Enable AutoComplete in Excel 2013


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.

example of autocomplete

 

Here is how to enable AutoComplete in Excel 2013 –

  1. Open Excel 2013.
  2. Click the File tab at the top-left corner of the window.
  3. Click Options at the bottom of the column at the left side of the window.
  4. Click Advanced in the left column of the Excel Options window.
  5. 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.

click the file tab

 

 

Step 3: Click Options in the column at the left side of the window, which opens the Excel Options window.

click options in the left column

 

 

Step 4: Click the Advanced tab in the Excel Options window.

click advanced tab

 

 

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.

enable autocomplete in excel 2013

 

 

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.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.