Accept and apply
Windows shortcut
Enter
Mac shortcut
Return
This shortcut will accept and apply the settings in the dialog box.
Related videos
The videos below demonstrate this shortcut.
In this video we show you the difference between finding formulas and finding values (e.g. 100 vs. $100.00).
In this video we'll look at how to create 3D references; an elegant way to analyze multiple worksheets with simple formulas.
How to use your keyboard to navigate dialog boxes in Excel for the Mac
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.