Open options
Windows shortcut
AltFT
Mac shortcut
⌘,
This shortcut will open Excel's options area. We don't know of a dedicated shortcut for this in Windows, so you'll need to use Alt + F to open the File menu, then T to access the Options window.
On the Mac, options are called "preferences", and the shortcut command + , will open preferences in most applications, not just Excel.
Related videos
The videos below demonstrate this shortcut.
In this video, we'll look at the options available for Excel Tables, including automatic range expansion and a setting to automatically fill formulas.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
