Excel Keyboard Shortcuts for Windows and Mac (Cheat Sheet)
The shortcuts that save the most time in Excel, grouped by the task you are doing, with the Windows and Mac keys side by side. Finance interview guides single out a handful as the moves a timed test assumes: Ctrl + Shift + Arrow to select a block, F2 to edit, F4 to lock a reference, Alt + = for AutoSum, Ctrl + 1 for the Format Cells dialog. Learn those five first.
Mac keys: ⌘ is Command, ⌥ is Option, ⌃ is Control. Fn is needed for function keys on most Mac keyboards. A comma means press the keys in sequence.
Selection
| Действие | Windows | Mac |
|---|---|---|
| Extend the selection to the edge of the blockThe selection move timed tests assume. Disabled in some simulations. | Ctrl+Shift+Arrow | ⌘+Shift+Arrow |
| Select the current regionPress again for the whole sheet. | Ctrl+A | ⌘+A |
| Select the whole column | Ctrl+Space | ⌃+Space |
| Select the whole row | Shift+Space | Shift+Space |
| Extend the selection one cell | Shift+Arrow | Shift+Arrow |
| Select to the start of the row | Shift+Home | Fn+Shift+← |
| Select to A1 | Ctrl+Shift+Home | Fn+⌃+Shift+← |
| Select visible cells only | Alt+; | ⌘+Shift+Z |
Editing
| Действие | Windows | Mac |
|---|---|---|
| Edit the active cell | F2 | ⌃+U |
| Enter and stay in the cellWith a range selected, fills every cell with the entry. | Ctrl+Enter | ⌃+Return |
| New line inside a cell | Alt+Enter | ⌃+⌥+Return |
| Copy, cut, paste | Ctrl+C / X / V | ⌘+C / X / V |
| Paste SpecialThen V for values, T for formats. | Ctrl+Alt+V | ⌘+⌃+V |
| Undo and redo | Ctrl+Z / Y | ⌘+Z / Y |
| Fill down from the cell above | Ctrl+D | ⌘+D |
| Fill right from the cell to the left | Ctrl+R | ⌘+R |
| Insert the current date | Ctrl+; | ⌃+; |
| Insert the current time | Ctrl+Shift+; | ⌘+; |
| Insert rows, columns or cellsSelect whole rows or columns first to skip the dialog. | Ctrl+Shift++ | ⌃+I |
| Delete rows, columns or cells | Ctrl+- | ⌘+- |
| Flash Fill | Ctrl+E | ⌃+E |
| Insert a comment or note | Shift+F2 | Fn+Shift+F2 |
Formatting
| Действие | Windows | Mac |
|---|---|---|
| Format Cells dialogNumber formats, alignment, borders, fill in one place. | Ctrl+1 | ⌘+1 |
| Bold, italic, underline | Ctrl+B / I / U | ⌘+B / I / U |
| Currency format | Ctrl+Shift+4 | ⌃+Shift+4 |
| Percentage format | Ctrl+Shift+5 | ⌃+Shift+5 |
| Number format with two decimals | Ctrl+Shift+1 | ⌃+Shift+1 |
| Date format | Ctrl+Shift+3 | ⌃+Shift+3 |
| General format | Ctrl+Shift+~ | ⌃+Shift+~ |
| Outline border | Ctrl+Shift+& | ⌘+⌥+0 |
| Remove borders | Ctrl+Shift+_ | ⌘+⌥+- |
| Hide the selected rowsCtrl + Shift + 9 unhides. | Ctrl+9 | ⌃+9 |
| Hide the selected columns | Ctrl+0 | ⌃+0 |
Formulas
| Действие | Windows | Mac |
|---|---|---|
| AutoSum | Alt+= | ⌘+Shift+T |
| Cycle $ through a referenceWhile editing: B1, $B$1, B$1, $B1. Fn + F4 also works on Mac. | F4 | ⌘+T |
| Show formulas instead of values | Ctrl+` | ⌃+` |
| Recalculate all open workbooks | F9 | Fn+F9 |
| Insert a function | Shift+F3 | Fn+Shift+F3 |
| Expand the formula bar | Ctrl+Shift+U | ⌃+Shift+U |
| Enter an array formula (older Excel)Not needed in Excel 365, where formulas spill on their own. | Ctrl+Shift+Enter | ⌃+Shift+Return |
| Define a name for the selection | Ctrl+F3 | Fn+⌃+F3 |
Filters, tables and data
| Действие | Windows | Mac |
|---|---|---|
| Turn AutoFilter on or off | Ctrl+Shift+L | ⌘+Shift+F |
| Open the filter menu of the active header | Alt+↓ | ⌥+↓ |
| Create a tableCtrl + L also works on Windows. | Ctrl+T | ⌘+T |
| Data validation dialogWindows ribbon sequence; on Mac use Data > Data Validation. | Alt+D, L | — |
| Remove duplicatesWindows ribbon sequence; on Mac use Data > Remove Duplicates. | Alt+A, M | — |
| Sort dialogWindows ribbon sequence. | Alt+A, S, S | — |
| Group rows or columns | Alt+Shift+→ | ⌘+Shift+K |
| Ungroup | Alt+Shift+← | ⌘+Shift+J |
| Create a PivotTableWindows ribbon sequence; on Mac use Insert > PivotTable. | Alt+N, V, T | — |
Sheets, windows and files
| Действие | Windows | Mac |
|---|---|---|
| New worksheet | Shift+F11 | Fn+Shift+F11 |
| Freeze panesWindows ribbon sequence; on Mac use View > Freeze Panes. | Alt+W, F, F | — |
| Rename the sheetOr double-click the tab on either platform. | Alt+H, O, R | — |
| Save | Ctrl+S | ⌘+S |
| Save As | F12 | ⌘+Shift+S |
| Open and new workbook | Ctrl+O / N | ⌘+O / N |
| Ctrl+P | ⌘+P | |
| Switch between open workbooks | Ctrl+Tab | ⌘+~ |
| Close the workbook | Ctrl+W | ⌘+W |
What is different in Excel for the web?
Excel for the web runs inside the browser, so shortcuts that the browser claims come first: Ctrl + F opens the browser search unless Excel has focus in the grid, Ctrl + W closes the tab, Ctrl + P prints the page. Most cell shortcuts (Ctrl + Arrow, Ctrl + Shift + Arrow, F2, Ctrl + 1, Alt + =) work; the Alt ribbon sequences (Alt, then letters) do not. Use Alt + Q or the Tell Me box to run a command by name instead.
Browser-based test simulations go further: Criteria states that most selection and command shortcuts, including Ctrl + Shift + Arrow and Ctrl + C, are not supported in its simulation, while arrow keys and Enter are; SHL-type tests disable many shortcuts as well. Practise the mouse route to each command as well as the keys.
Which shortcuts do Excel tests ask about?
Multiple-choice screenings ask about shortcuts directly: iMocha's basic test lists keyboard shortcuts as a topic, Mettl's intermediate test asks for the AutoSum shortcut, and CFI's free test asks what F4 and F2 do. Investment-banking modeling guides expect keyboard-only speed and name Ctrl + Shift + Arrow, Ctrl + Alt + V, Ctrl + 1, F2, F4 and Alt + = specifically.
In our exercises every shortcut in the grid works on both platforms, and the Check button has one too: Ctrl + Enter on Windows, ⌘ + Enter on Mac.
Вопросы о горячих клавишах Excel
What is the shortcut to lock a cell reference in Excel?
F4 while editing the formula, with the cursor in the reference. Each press cycles B1 to $B$1, B$1, $B1 and back. On a Mac, ⌘ + T or Fn + F4.
What is the shortcut for AutoSum?
Alt + = on Windows, ⌘ + Shift + T on Mac. It inserts a SUM over the numbers above or to the left of the selected cell.
Do Excel shortcuts work on a Mac?
Most do, with ⌘ in place of Ctrl for file and clipboard commands and ⌃ for many cell commands. The Alt ribbon sequences (Alt, then letters) are Windows only; on a Mac use the menu bar or the ribbon with the mouse.
Do shortcuts work in Excel for the web?
Cell shortcuts mostly do; ribbon key sequences do not, and a few keys go to the browser first. Test simulations that run in the browser disable more of them, so know the mouse route too.
Попробуйте в настоящей таблице
Бесплатно, без регистрации и без установки.
Excel — товарный знак группы компаний Microsoft. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria и другие товарные знаки принадлежат их владельцам. GridBelt — независимый проект: он не связан ни с одной из этих компаний, не одобрен и не спонсируется ими.