How to Turn Off Formula AutoComplete in Excel 2013

Formulas are an important part of many Excel spreadsheets, and are one of the main reasons that it can be such a helpful tool in a wide range of projects. Excel supports a lot of different formulas, many of which have their own special formats. In order to help with your usage of the program, there is a setting that can autocomplete some of these formulas for you as you type.

But if you don’t like the autocomplete option for your formulas, then you might be looking for a way to turn it off. Our guide below will show you how to do this in Excel 2013.


How to Disable the AutoComplete Option for Formulas in Excel 2013

The steps in this article were performed in Microsoft Excel 2013. This tutorial assumes that you are currently experiencing behavior in Excel 2013 where, as you begin typing a formula into a cell, Excel will provide an “autocomplete” function where it guess what you are trying to do. If you find that to be problematic or distracting, then continue below to see how you can turn it off.

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.

open excel options



Step 4: Click the Formulas tab in the left column of the Excel Options menu.

click the formulas tab



Step 5: Uncheck the box to the left of Formula AutoComplete, then click the OK button at the bottom of the window to apply the changes.

how to disable formula autocomplete in excel 2013



Do you have a formula that you need to place in a text box, but you are struggling to make it work? Learn how to work with text boxes and formulas in Excel 2013 and see what your options are.