Excel Formula Shortcuts
Every Excel formula shortcut in one place. Open any shortcut for Windows, Mac and Web keys, steps and alternatives.
Excel Formula Keyboard Shortcuts
- Excel AutoSum shortcut
Adds a SUM formula for the cells above.
Alt+=Mac: Cmd + Shift + T - Excel Sum Column shortcut
Totals the numbers above the active cell.
Alt+=Mac: Cmd + Shift + T - Excel Lock Cell Reference shortcut
Toggles $ signs to make a reference absolute.
F4Mac: Cmd + T - Excel Show Formulas shortcut
Shows formulas instead of results.
Ctrl+`Mac: Ctrl + ` - Excel Edit Cell shortcut
Puts the active cell into edit mode.
F2Mac: Ctrl + U - Excel Fill Down shortcut
Copies the cell above into the selected cells.
Ctrl+DMac: Cmd + D - Excel Fill Right shortcut
Copies the cell on the left into the selected cells.
Ctrl+RMac: Cmd + R - Excel Autofill shortcut
Continues a series down using Flash Fill.
Ctrl+E - Excel Insert Current Date shortcut
Types today's date into the cell.
Ctrl+;Mac: Ctrl + ; - Excel Insert Current Time shortcut
Types the current time into the cell.
Ctrl+Shift+;Mac: Cmd + ; - Excel New Line in Cell shortcut
Starts a new line inside the same cell.
Alt+EnterMac: Option + Enter