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