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.


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. newsletter

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