-
Go to Excel and choose Preferences.
-
Select AutoCorrect in the Preferences dialog.
-
Choose your AutoCorrect preferences 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 > Open in Desktop App.
Don't have the Excel desktop app? Try or buy Microsoft 365.