How to enable and disable Microsoft Excel AutoFormat feature

To enable or disable the AutoFormat feature and its options in Microsoft Excel, follow the steps below for the version of Excel on your computer.

Microsoft Excel 2007 and later

1. Open Microsoft Excel.
2. Click the File tab.
3. Click the Options link in the left navigation pane.
4. In the Excel Options window, click the Proofing option in the left navigation pane.
5. Click the AutoCorrect Options button.
6. In the AutoCorrect window, click the AutoFormat tab.

In this section, users can enable or disable each of the AutoFormat features they do not want to use.

Microsoft Excel 2003 and earlier

1. Open Microsoft Excel.
2. In the menu bar, click Format and select AutoFormat.
3. Click the Options button.

In this section, users can enable or disable each of the AutoFormat features they do not want to use.