The best Excel keyboard shortcuts for Mac

You can master one of the most complete applications of the Microsoft Office suite if you learn its main keyboard shortcuts properly. This will let you be more productive and perform different actions faster, even without lifting your hands from the keyboard. Here is a list of basic and advanced functions that you can execute from the keyboard.

Common Features

  • CMD + N: Open a new spreadsheet.
  • CMD + O: Open an existing document
  • CMD + W: Close the active window without exiting the program.
  • CMD + S: Save the spreadsheet.
  • CMD + X: Cut the selection to the clipboard.
  • CMD + C: Copy the selection to the clipboard.
  • CMD + V: Paste the contents of the clipboard
  • CMD + P: Print the current spreadsheet.
  • CMD + F: Search for text in the active spreadsheet
  • CMD + Z: Undo the last action.
  • CMD + Y: Redo the last action.
  • CMD + I: Put the selected text in italics.
  • CMD + B: Make the selected text bold.
  • CMD + U: Underline the selected text.

Control of cells and formulas

  • Ctrl + Shift + Backspace: Enter a matrix formula.
  • Backward: End the input in a cell.
  • Escape: Cancel the entry in the cell or the formulation bar.
  • Ctrl + A: Display the Formula Generator when entering a valid function in a formula.
  • CMD + K: Insert a hyperlink.
  • Ctrl + U: Edit the active cell and place the insertion point at the end of the line.
  • CMD + =: Calculate all sheets in all open books.
  • CMD + Shift + =: Calculate the entire active sheet.
  • =: Start a formula.
  • CMD + Shift + T: Insert the AutoSum formula
  • Ctrl + ;: Include the date.
  • CMD + ;: Include the time.
  • Ctrl + Shift + ": Copy the value of the cell located above the active one or in the formula bar.
  • Ctrl + `: Alternate display of cell values and formulas on the sheet.
  • Ctrl + ': Copy a formula from the cell above the active one or in the formula bar.
  • Ctrl + Option + ↓: Show the Autocomplete list.
  • Ctrl + L: Assign name.

Shortcuts for graphics, filters, and diagrams

  • F11: Add a new chart sheet.
  • Direction keys: Move the graphic object selection.
  • CMD + Shift + R: Open the sort dialog box.
  • CMD + Shift + F: Add or remove a filter.
  • Option + ↓: Show the list of filters or the page in the current cell.
  • Control + 8: Show or hide outline symbols.
  • Control + 9: Hide selected rows.
  • Control + Shift + (: Show the selected rows.
  • Control + zero: Hide the selected columns.
  • Control + Shift + ): Show the selected columns.

Function key shortcuts

  • F1: Show the Help window.
  • F2: Edit the selected cell.
  • Shift+F2: Insert a note and open and modify a cell note.
  • CMD + Shift + F2: Insert a chained comment, open it or answer it.
  • Option + F2: Save.
  • Shift + F3: Start the formula generator.
  • CMD + F3: Open the Define Name dialog box.
  • CMD + F4: Close the application.
  • F5: Show the Go to page dialog.
  • Shift + F5: Show the Search dialog.
  • Control + F5: Go to the Find Sheet dialog.
  • F7: Start spelling check.
  • Shift + F7: Open the thesaurus.
  • F8: Extend the selection.
  • Shift + F8: Add to selection
  • OPTION + F8: Show Macros.
  • F9: Calculate all open books.
  • Shift + F9: Calculate the active sheet.
  • Control + F9: Minimize the active window.
  • Shift + F10: Show a context menu.
  • CMD + F10: Maximize or restore the active window
  • Shift + F11: Insert a new sheet.
  • Option + F11: Start Visual Basic.
  • F12: Save as.
  • CMD + F12: Show the Open dialog.