Cmd+Z

Ctrl+Z

Undo the last action

Cmd+Y

Ctrl+Y

Redo the last action

Cmd+↓

Ctrl+↓

Navigates to the last row of the current selection

↓

↓

Navigates down to the next cell

Fn+→

End

Navigates to the end of the row

Cmd+→

Ctrl+→

Navigates to the last column in the current selection

Cmd+Fn+←

Ctrl+Home

Navigates to cell "A1" on the current sheet

Fn+←

Home

Navigates to the first column in the selected row

Cmd+←

Ctrl+←

Navigates to the first column in the current sheet

Cmd+Fn+→

Ctrl+End

Navigates to the last (bottom right) cell on the current sheet

←

←

Navigates one cell to the Left

Tab

Tab

Navigates to the next cell to the right

Fn+↓

Page Down

Navigates to the next page of rows down

Fn+↑

Page Up

Navigates to the page of rows up

Cmd+Fn+↑

Ctrl+Alt+Page Up

Navigates to the previous sheet

Cmd+Fn+↓

Ctrl+Alt+Page Down

Navigates to the next sheet

Shift+Tab

Shift+Tab

Navigates to the cell to the left

→

→

Navigates one cell to the right

Cmd+↑

Ctrl+↑

Navigates to the first row of the current selection

↑

↑

Navigates one cell up

Delete

Delete

Deletes the selected cells

Fn+Delete

Back

Deletes the selected cell or the the leftmost cell in a row and the top cell in a column

Enter

Enter

Enters the contents of the active cell and navigates to the cell above (by default)

Shift+Enter

Shift+Enter

Enters the contents of the active cell and navigates to the cell below (by default)

Esc

Esc

Cancels an entry

Shift+←

Shift+←

Extends the cell selection to the left

Shift+→

Shift+→

Extends the cell selection to the right

Shift+↑

Shift+↑

Extends the cell selection up

Shift+↓

Shift+↓

Extends the cell selection down

Shift+Fn+←

Shift+Home

Extends the selection to the first column

Cmd+Shift+←

Ctrl+Shift+←

Navigates across text, by whole words

Shift+Fn+→

Shift+End

Selects all text in the current line

Cmd+Shift+→

Ctrl+Shift+→

Ctrl + Right navigates across text, by whole words

Shift+Fn+↑

Shift+Page Up

Extends the selection up one screen

Shift+Fn+↓

Shift+Page Down

Extends the selection down one screen

Cmd+Shift+↑

Ctrl+Shift+↑

Selects the cells in the column from selection up and jumps to the top cell

Cmd+Shift+↓

Ctrl+Shift+↓

Selects the cells in the column from selection down and jumps to the bottom cell

Cmd+Shift+Fn+←

Ctrl+Shift+Home

Selects the cells in the column from selection left and jumps to the left cell in the row

Cmd+Shift+Fn+→

Ctrl+Shift+End

Selects the cells in the column from selection right and jumps to the right cell in the row

Cmd+C

Ctrl+C

Copies the current selection

Cmd+X

Ctrl+X

Cuts (Copies and Deletes) the current selection

Cmd+V

Ctrl+V

Pastes selection

Option+Enter

Alt+Enter

Enters a new line into a cell

Shift+Space

Shift+Space

Selects the entire row

Ctrl+Space

Ctrl+Space

Selects the entire column

Cmd+-

Ctrl+-

Deletes the entire row or column

Cmd+Shift+=

Ctrl+Shift+=

Inserts rows or columns depending on the selection

Cmd+9

Ctrl+9

Hide select rows

Cmd+Shift+9

Ctrl+Shift+9

Unhide select rows

Cmd+0

Ctrl+0

Hide select columns

Cmd+Shift+0

Ctrl+Shift+0

Unhide select columns

Cmd+[

Ctrl+[

Selects all the cells that are directly referred to by the formula in the active cell (precedents)

Cmd+]

Ctrl+]

Selects all the cells that directly refer to the active cell (dependents)

Cmd+;

Ctrl+;

Inserts the current date into the selected cells

Option+=

Alt+=

Enters the SUM() function (AutoSum) to sum the adjacent block of cells

Option+;

Alt+;

Selects all visible cells in the current selection

Cmd+D

Ctrl+D

Copies the first cell in the selection downwards

Cmd+R

Ctrl+R

Copies the first cell in the selection right

Cmd+A

Ctrl+A

Selects all from the current sheet

Cmd+B

Ctrl+B

Bold cell text

Cmd+I

Ctrl+I

Italicize cell text

Cmd+Shift+X

Ctrl+Shift+X

Strikethrough cell text

Cmd+U

Ctrl+U

Underline cell text

Cmd+Shift+1

Ctrl+Shift+1

Set number format

Cmd+Shift+3

Ctrl+Shift+3

Set date format

Cmd+Shift+4

Ctrl+Shift+4

Set currency format

Cmd+Shift+5

Ctrl+Shift+5

Set percent format