-
One the File tab, select Options.
-
Choose Proofing.
-
Select AutoCorrect Options, choose your preferences, and then select OK.
-
On the Excel menu, select Preferences.
-
Select
AutoCorrect in the Preferences dialog. -
Select or clear AutoCorrect options and close the dialog.
Setting AutoCorrect options isn't currently possible in Excel for the web. You can, however, set AutoCorrect options in the Excel desktop app.
-
To open the desktop app, at the top of the ribbon, select Editing and choose Open in Desktop App.
Don't have the Excel desktop app? Try or buy Microsoft 365.