Keyboard Shortcuts
| Action | Description | Windows | macOS |
|---|---|---|---|
| Copy | Copies the selected cells. | Ctrl + C | Cmd + C |
| Paste | Pastes copied cells. | Ctrl + V | Cmd + V |
| Cut | Cuts the selected cells. | Ctrl + X | Cmd + X |
| Undo | Undoes the last action. | Ctrl + Z | Cmd + Z |
| Redo | Redoes the last undone action. | Ctrl + Y | Cmd + Y |
| Save | Saves the current workbook. | Ctrl + S | Cmd + S |
| Save As | Opens the Save As dialog box. | F12 | Cmd + Shift + S |
| Opens the Print dialog box. | Ctrl + P | Cmd + P | |
| Bold | Applies or removes bold formatting. | Ctrl + B | Cmd + B |
| Italic | Applies or removes italic formatting. | Ctrl + I | Cmd + I |
| Underline | Applies or removes underlining. | Ctrl + U | Cmd + U |
| Strikethrough | Applies or removes strikethrough. | Ctrl + 5 | Cmd + Shift + X |
| Format Cells | Opens the Format Cells dialog box. | Ctrl + 1 | Cmd + 1 |
| Apply Outline Border | Applies an outline border to selected cells. | Ctrl + Shift + & | Cmd + Option + 0 |
| Remove Borders | Removes all borders from selected cells. | Ctrl + Shift + _ | Cmd + Option + - |
| Select All | Selects the entire worksheet. | Ctrl + A | Cmd + A |
| Select Column | Selects the current column. | Ctrl + Space | Ctrl + Space |
| Select Row | Selects the current row. | Shift + Space | Shift + Space |
| Go To | Opens the Go To dialog box. | Ctrl + G or F5 | Cmd + G or Fn + F5 |
| Go to Start of Row | Moves to the beginning of the row. | Home | Home |
| Go to Start of Worksheet | Moves to the beginning of the worksheet (cell A1). | Ctrl + Home | Cmd + Home |
| Go to End of Worksheet | Moves to the last cell with content on the worksheet. | Ctrl + End | Cmd + End |
| Next Worksheet | Switches to the next worksheet. | Ctrl + Page Down | Fn + Ctrl + Down Arrow |
| Previous Worksheet | Switches to the previous worksheet. | Ctrl + Page Up | Fn + Ctrl + Up Arrow |
| Insert Hyperlink | Opens the Insert Hyperlink dialog box. | Ctrl + K | Cmd + K |
| Fill Down | Fills the cell(s) below with the content of the top cell. | Ctrl + D | Cmd + D |
| Fill Right | Fills the cell(s) to the right with the content of the leftmost cell. | Ctrl + R | Cmd + R |
| Flash Fill | Automatically fills values into the active column. | Ctrl + E | Ctrl + E |
| Insert Row/Column | Inserts a new row or column. | Ctrl + Shift + + | Cmd + Shift + + |
| Delete Row/Column | Deletes the selected row or column. | Ctrl + - | Cmd + - |
| AutoSum | Inserts the SUM formula for the adjacent cells. | Alt + = | Cmd + Shift + T |
| Enter Current Date | Inserts the current date. | Ctrl + ; | Ctrl + ; |
| Enter Current Time | Inserts the current time. | Ctrl + Shift + : | Cmd + ; |
| Show Formulas | Toggles the display of formulas in cells. | Ctrl + ` | Ctrl + ` |
| Edit Active Cell | Puts the cursor at the end of the content of the active cell. | F2 | F2 |
| Create Table | Opens the Create Table dialog box. | Ctrl + T | Cmd + T |
| Create Chart | Creates a chart of the data in the current range on the same sheet. | Alt + F1 | Fn + Option + F1 |
| Create Chart on New Sheet | Creates a chart on a new chart sheet. | F11 | Fn + F11 |
| Find | Opens the Find and Replace dialog box (Find tab). | Ctrl + F | Cmd + F |
| Replace | Opens the Find and Replace dialog box (Replace tab). | Ctrl + H | Cmd + H |
| Open a Workbook | Opens the file open dialog. | Ctrl + O | Cmd + O |
| New Workbook | Creates a new blank workbook. | Ctrl + N | Cmd + N |
| Help | Opens the Help pane. | F1 | Fn + F1 |
| Activate Filter | Toggles the filter controls on the selected range. | Ctrl + Shift + L | Cmd + Shift + F |