The Unwanted List Formatting
Microsoft Excel borrows several “smart” formatting features from Microsoft Word to make data entry easier. One of these features is automatic bulleted lists. If you click into an Excel cell, type an asterisk (*) or a hyphen (-), hit the spacebar, and begin typing a sentence, Excel will instantly “correct” your formatting. It replaces your asterisk with a formal, indented bullet point, converting your simple text into a structured list. While this is helpful if you are actually trying to write a list inside a cell, it is incredibly annoying if you are simply trying to write a mathematical equation (like - 500 for a negative transaction) or using an asterisk to indicate a footnote. Excel ruins your raw data by forcing it into a Word-style layout.
How to Disable AutoFormat for Bulleted Lists
You can turn off this specific AutoFormat rule deep within Excel’s Proofing settings, forcing the application to treat asterisks and hyphens as plain text characters rather than list triggers.
1. Open Microsoft Excel.
2. Click on the File tab in the top-left corner of the ribbon.
3. At the very bottom of the left-hand sidebar, click on Options.
4. In the Excel Options dialog box, select Proofing from the left-hand menu.
5. Click the AutoCorrect Options… button at the top of the main pane.
6. A new dialog box will appear. Click on the AutoFormat As You Type tab.
7. Look under the section labelled “Apply as you type.”
8. Uncheck the box next to Automatic bulleted lists.
9. Click OK to close the AutoCorrect box, and click OK again to close the Excel Options box.
From now on, when you type an asterisk or a hyphen followed by a space, Excel will leave it exactly as you typed it, completely ignoring the list formatting rules.
How to Bypass Auto-Bullets on the Fly
If you don’t want to change the global setting because you occasionally do want automatic lists, you can easily bypass the formatting on a case-by-case basis using the apostrophe trick.
When you want to type an asterisk or hyphen without triggering a list:
1. Click the cell.
2. Type a single apostrophe (‘) first.
3. Then type your asterisk or hyphen and your text (e.g., '* Important Note).
4. Press Enter.
The apostrophe tells Excel, “Treat everything that follows this exact character as plain text, regardless of any AutoFormat rules or mathematical formulas.” The apostrophe will disappear from the visible spreadsheet, but your asterisk will remain untouched and unformatted.