Skip to the main content
Shortivo

Microsoft Excel keyboard shortcuts

Spreadsheet editing, formatting, selection, and formula shortcuts.

34 shortcuts Mac and Windows checked September 11, 2026

Print all 34 shortcuts One sheet with every shortcut in this app, ready for the printer or a PDF.

Every system Mac Windows
Everything Clipboard Comments and review Editing Files and printing Formulas and data Navigation Paragraphs and lists Selection Text formatting View and zoom
Matching shortcuts
Action Keys Row actions
Change cell formatting Opens Format Cells Windows Ctrl1 Source
Edit the current cell Cell editing Windows F2 Source
Stamp today's date Inserts a fixed date Windows Ctrl; Source
Start a SUM calculation AutoSum Windows Alt= Source
Turn a range into a table Select the data first Windows CtrlT Source
Break a line inside a cell While editing cell text Windows AltEnter Source
Copy the top cell downward Select the source and destination range Windows CtrlD Source
Highlight the whole column Worksheet selection Windows CtrlSpace Source
Highlight the whole row Worksheet selection Windows ShiftSpace Source
Change formula reference locking Select a reference while editing a formula Windows F4 Source
Copy selection Selection Mac CmdC 1 more variant Source
Cut selection Selection Mac CmdX 1 more variant Source
Paste clipboard Destination Mac CmdV 1 more variant Source
Undo change Workbook Windows CtrlZ Source
Open workbook File Windows CtrlO Source
Save workbook File Windows CtrlS Source
Close workbook File Windows CtrlW Source
Clear contents Selected cells Windows Delete Source
Bold Selected cells Windows CtrlB Source
Italic Selected cells Windows CtrlI Source
Underline Selected cells Windows CtrlU Source
Strikeout Selected cells Windows Ctrl5 Source
Paste Special Clipboard Windows CtrlAltV Source
Show formulas Worksheet Windows Ctrl` Source
Edit note Cell note Windows ShiftF2 Source
Threaded comment Cell comment Windows CtrlShiftF2 Source
Hide rows Selection Windows Ctrl9 Source
Hide columns Selection Windows Ctrl0 Source
Next sheet Workbook Windows CtrlPage Down Source
Previous sheet Workbook Windows CtrlPage Up Source

About Microsoft Excel and its shortcuts

Excel is the spreadsheet most offices run on, and it rewards keyboard work more than almost any other program here. Its shortcuts fall into three worlds that behave differently: moving and selecting across a grid, editing what is inside one cell, and acting on the sheet or workbook around them. People who work quickly in Excel are usually fluent in the first two and barely touch the mouse.

Microsoft documents Windows and Mac separately, and the two are genuinely different rather than translations of each other. Excel for the web supports a smaller set again, and a few combinations are intercepted by the browser before the sheet sees them. Check which Excel you are in before blaming the keys.

Where the Microsoft Excel keys came from

Read from 1 documentation page published by the makers of Microsoft Excel. Report a key that is wrong

To see how one action is done in other apps as well as Microsoft Excel, browse the shortcuts by task. Shortcuts by task