Mac Apple Keyboard - Numbers keyboard shortcuts

A lot of the keyboard shortcuts available for apps on Mac are the same across those applications. Things like cut, copy, paste, close, or quit are often times the same, especially for Apple’s apps like Pages, Numbers, and Keynote.

So in this list of keyboard shortcuts for Numbers, we’ve included some that you would only by using in Numbers; shortcuts for working with tables. But you’ll also find the basics for controlling the Numbers window and working in spreadsheets.

The Numbers window

Control the Numbers window by minimizing it, hiding it, or closing it using these helpful keyboard shortcuts.

  • Minimize the window: Command + M
  • Minimize all windows: Option + Command + M
  • Hide Numbers: Command + H
  • Hide all other app windows: Option + Command + H
  • Enter full-screen mode: Control + Command + F
  • Zoom in: Command + > (right angle bracket)
  • Zoom out: Command + < (left angle bracket)
  • Zoom to selection: Shift + Command + 0 (zero)
  • Return to normal size: Command + 0 (zero)
  • Open Numbers preferences: Command + , (comma)
  • Open the Numbers User Guide: Shift + Command + ? (question mark)
  • Close the window: Command + W
  • Close all windows: Option + Command + W
  • Quit Numbers: Command + Q
  • Quit Numbers with windows open: Option + Command + Q

Keyboard shortcuts for spreadsheets

Work with your spreadsheets like opening the Template Chooser, duplicating or printing a spreadsheets, and starting dictation with these shortcuts.

  • Open the Template Chooser: Command + N
  • Close the Template Chooser: Escape
  • Start dictation: Press Fn twice
  • Open an existing spreadsheet: Command + O (capital letter “o”)
  • Save a spreadsheet: Command + S
  • Save a spreadsheet as: Option + Shift + Command + S
  • Duplicate a spreadsheet: Shift + Command + S
  • Print a spreadsheet: Command + P
  • Undo: Command + Z
  • Redo: Shift + Command + Z

Keyboard shortcuts for navigating within sheets

While you’re working on your spreadsheet, you can move up, down, left, right, and more with these shortcuts.

  • Move left one character: Left arrow
  • Move right one character: Right arrow
  • Move back one character: Control + B
  • Move forward one character: Control + F
  • Move up one line: Up arrow
  • Move down one line: Down arrow
  • Move to the start of the current or previous word: Control + Option + B
  • Move to the end of the current or previous word: Control + Option + F
  • Move to the start of the text area: Command + Up arrow
  • Move to the end of the text area: Command + Down arrow
  • Scroll up the sheet: Page Up
  • Scroll down the sheet: Page Down
  • Scroll to the start of the sheet: Home or Fn + Up arrow
  • Scroll to the end of the sheet: End or Fn + Down arrow
  • Go down a page: Control + V

Keyboard shortcuts for tables

Your Numbers sheets are all about tables, so these helpful shortcuts will help you add rows, delete columns, and select content in tables.

  • Select a cell: Click the cell
  • Select the next cell: Tab
  • Select the previous cell: Shift + Tab
  • Select the cell below: Return
  • Select the cell above: Shift + Return
  • Select the cell to the right, left, up, or down: Press the corresponding arrow key
  • Select the first cell in a table: Option + Return
  • Select a table from a selected cell: Command + Return
  • Select a row or column: Click the letter for the column or number for the row
  • Select the rows that intersect the selection: Option + Command + Return
  • Select the columns that intersect the selection: Control + Command + Return
  • Select additional rows: Shift + Up arrow/Down arrow
  • Select additional columns: Shift + Right arrow/Left arrow
  • Select additional cells: Shift + click
  • Select body cells in a row or column: Double-click the letter for the column or number for the row
  • Select all content in a table: Command + A
  • Insert a row above the selected cells: Option + Up arrow
  • Insert a row below the selected cells: Option + Down arrow
  • Insert a row at the bottom of the table: Select a cell in the bottom row and hit Return
  • Insert a column to the right of selected cells: Option + Right arrow
  • Insert a column to the left of selected cells: Option + Left arrow
  • Insert a column all the way to the right of the table: Select a cell in the right-most column and hit Tab
  • Delete selected rows: Option + Command + Delete
  • Delete selected columns: Control + Command + Delete
  • Apply sorting rules: Shift + Command + R
  • Turn on or off filters: Shift + Command + F
  • Turn on autofill mode: Command + \ (backslash)
  • Merge selected cells: Control + Command + M
  • Unmerge selected cells: Control + Shift + Command + M

Wrapping it up

Hopefully these shortcuts will come in handy the next time you’re working with Numbers on your Mac.

Be sure to check out our keyboard shortcuts section for other helpful ways to maneuver and control apps on your Mac.