How to Enable Formula AutoComplete in Excel 2013

Excel 2013 contains a large library of formulas that offer a variety of different mathematical operations. If you have difficulty remembering all of the formulas contained within the program, then you might find the Formula AutoComplete option to be very useful. This setting allows you to start typing a formula into a cell, at which point Excel will display a list of formulas that start with the letters you are typing.

The Formula AutoComplete setting can be disabled, however, from the Excel Options menu. If it is not working on your computer and you would like to fix that, then read our steps below to learn how to re-enable the setting.

You can also check out our tutorial on how to subtract in Excel and find out how to use a really versatile subtraction formula.

Adjusting the Default Formula AutoComplete Setting in Excel 2013

The steps in this article will assume that the Formula AutoComplete is currently disabled in your Excel 2013 settings. Once you have completed the steps below, you will be able to start typing a formula into a cell, and Excel will display an AutoComplete list that includes formula options you can click to use.

Step 1: Open Excel 2013.

Step 2: Click the File tab at the top-left corner of the window.

click the file tab

Step 3: Click the Options button at the bottom of the column on the left side of the window. This opens a new window called Excel Options.

click the options button

Step 4: Select the Formulas tab at the left side of the Excel Options window.

click the formulas tab

Step 5: Click the box to the left of Formula AutoComplete in the Working with formulas section of the menu. You can then click the OK button at the bottom of the window to apply your changes.

enable formula autocomplete

Now when you start typing a formula into a cell, you should see a list under the cell that offers some formula options for you. Clicking one of those options will enter the formula into the cell, at which point you will need to enter the values and the parameters for the formula.

formula autocomplete example

Do you have two columns of data that you need to combine, and are looking for a simple way to do it. Learn about the concatenate formula and see if its utility will improve your Excel experience.

Additional Sources newsletter

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