⌘ , : Open options
⌘ / : Open help
⌘ Z : Undo the last action
⌘ Y : Redo the last action
⌘ C : Copy selected cells
⌘ X : Cut selected cells
⌘ V : Paste content from clipboard
⌃ ⌘ V :Displays the Paste Special dialog box
⌘ F : Display find and replace
^ H :Displays find and replace, selected replacement
⌘ ⇧ G: Find the previous session
⌘ G : Find the next session
Fn ⌥ F1 : Create embedded chart
Fn F11 : Create a chart in a new spreadsheet
⌃ T : Insert table
⌘ ⇧ F : Switch filters automatically
⌥ ↓ :Activate filter
⇧ Space : Select multiple rows
⌃ Space : Select table column
⌘ A :Select table
⌥ C : Clear filter
⌘ ⇧ T : Convert total number of rows
drag : Drag and cut
⌥ drag : Drag and copy
⇧ drag : Drag and insert
⌥ ⇧ drag :Drag and insert copy
⌘ drag : Drag into the spreadsheet
⌥ drag : Drag to copy the spreadsheet
Fn ⌥ ↓ :Move one screen to the right
Fn ⌥ ↑ :Move one screen to the left
Fn ↑ :Move one screen up
Fn ↓ :Move one screen down
⌃ → :Move to the right edge of the data area
⌃ ← :Move to the left edge of the data area
⌃ ↑ :Move to the top edge of the data area
⌃ ↓ :Move to the bottom edge of the data area
Fn ← :Move to the beginning of the row
Fn ⌃ → :Move to the last cell in the spreadsheet
Fn ⌃ ← :Move to the first cell in the spreadsheet
Fn → :Enable End mode
^ G Return :Return to hyperlink
⇧ Space : Select the entire row
⌃ Space : Select the entire column
⌘ A : Select the entire spreadsheet
⇧ Click : Add adjacent cells to selection
⌘ Click : Adds non-adjacent cells to the selection
⌃ ⌥ → : Move immediately between non-adjacent selections
⌃ ⌥ ← : Move left between non-adjacent selections
Fn ⇧ F8 : Switch further into selection mode
Esc: Cancel selection
⇧ Delete : Select only the active cell
⌘ Delete : Displays the active cell on the spreadsheet
⌃ . : Move the active cell clockwise within the selection
Return : Moves the active cell down in the selection
⇧ Return : Move the active cell up in the selection
Tab: Moves the active cell within the selection
⇧ Tab : Move the active cell to the left in the selection
⇧ → : Extend selection by one cell to the right
⇧ ← : Extend selection by one remaining cell
⇧ ↑ : Expand selection by one cell up
⇧ ↓ : Extend selection by one cell down
⌃ ⇧ → : Extend selection to the last cell
⌃ ⇧ ← : Extend selection to the last cell on the left
⌃ ⇧ ↑ : Extend the selection to the last cell up
⌃ ⇧ ↓ : Extend selection to the last cell down
Fn ⇧ ↑ : Extend selection to one screen
Fn ⇧ ↓ : Extend selection down one screen
Fn ⇧ ⌘ ↓ : Extend selection immediately one screen
Fn ⇧ ⌘ ↑ : Expand selection to the left one screen
Fn ⇧ ← : Expand selection to start of row
Fn ⌃ ⇧ ← : Extend selection to the first cell in the spreadsheet
Fn ⌃ ⇧ → : Extend selection to the last cell in the spreadsheet
Fn F8 : Switch extended selection mode
⌃ G : Displays the 'Go To' dialog box
Fn ⌃ ⇧ O : Select cells with comments
⇧ ⌃ Space : Selects the current area around the active cell
⌘ A : Select current area
⌃ / : Selects the current array
⌃ : Select row difference
⌃ ⇧ | : Select column difference
⌃ [ : Select direct precedent
⌃ ⇧ { : Select all precedents
⌃ ] : Select direct dependents
⌃ ⇧ }: Select all dependents
⌘ ⇧ Z : Select only visible cells
⌃ U : Edit currently selected cell
Fn ⇧ F2 : Insert or edit comment
Esc : Cancel item
⇧ → : Select a correct character
⇧ ← : Select one remaining character
⌃ → : Move one word right
⌃ ← : Move one word left
⌃ ⇧ →: Choose the correct word
⌃ ⇧ ← : Choose one remaining word
Fn ⇧ ← : Select to start cell
Fn ⇧ → : Select to the end of the cell
⌃ Delete : Delete to the end of the line
Delete: Delete the character to the left of the cursor
Return : Enter and move down
⇧ Return : Enter and move up
Tab : Enter and move right
⇧ Tab : Enter and move left
⌃ Return : Enter the same data into multiple cells
⌃ ; : Insert current date
⌃ ⇧ : : Inserts the current time
⌃ D: Fill in from the box above
⌃ R : Fill right from the left cell
⌃ ' : Copy the formula from the cell above
⌃ ⇧ ' : Copy the value from the cell above
⌘ K : Add hyperlink
⌘ 1 : Format (almost) everything
⌃ ⇧ F : Show formatting cells with the Font tab selected
⌘ B : Apply or remove bold formatting
⌘ I : Apply or remove italic formatting
⌘ U : Apply or remove underline
⌘ ⇧ X : Apply or remove strikethrough formatting
⌘ ⇧ W : Add or remove shadow font styles
⌘ ⇧ D : Add or remove outline font styles
⌘ E: Align center
⌘ L : Align left
⌘ R : Align right
⌃ ⌥ Tab : Indent
⌃ ⌥ ⇧ Tab : Remove indent
⌘ ⇧ > : Increase font size one step
⌘ ⇧ < : Decrease font size one step
⌃ ⇧ ~ : Apply general formatting
⌃ ⇧ $ : Apply currency formatting
⌃ ⇧ % : Apply percentage formatting
⌃ ⇧ ^ : Apply scientific format
⌃ ⇧ # : Apply date format
⌃ ⇧ @ : Apply time format
⌃ ⇧ ! : Apply number formatting
⌘ ⌥ 0 : Add border outline
⌘ ⌥ → : Add or remove right border
⌘ ⌥ ← : Add or remove left border
⌘ ⌥ ↑ : Add or remove a top border
⌘ ⌥ ↓ : Add or remove bottom border
⌘ ⌥ _ : Delete border
⌘ T : Converts absolute and relative references
Fn ⇧ F3 : Open the Insert Function Dialog dialog box
⌘ ⇧ T : Selected cell
^ ' : Turns formulas on and off
⌃ ⇧ A : Insert function arguments
⌃ ⇧ Return : Enter array formula
Fn F9 : Calculate spreadsheet
Fn ⇧ F9 : Calculate active worksheet
Fn F9 : Evaluate part of the formula
⌃ ⇧ U : Expand or collapse the formula bar
⌃ A : Dialog showing function arguments
Fn ⌃ F3 : Define name
Fn ⌃ ⇧ F3 : Define names by row and column labels
↓ Tab : Accept function with autocompletion
⌃ I: Insert row, insert column
⌃ – : Delete row, delete column
Fn Delete: Delete the contents of selected cells
⌃ 0 : Hide column
⌃ 9: Hide rows
⌃ ⇧ 9: Skip the line
⌃ ⇧ 0 : Unknown column
⌘ ⇧ K : Group of rows or columns
⌘ ⇧ J : Ungroup rows or columns
⌘ ⇧ K : Open group dialog box
⌘ ⇧ J : Opens the Ungroup dialog box
⌃ 8 : Hide or show sketch icon
⌥ ⌘ + : Zoom in
⌥ ⌘ – : Zoom out
⌘ A : Select the entire pivot table
Space : Toggle the axis table field checkbox
⌘ ⇧ K: Pillar table group
⌘ ⇧ J : Pivot table entries
Ctrl – : Hide pivot table item
Fn F11 : Create a pivot chart on a new spreadsheet
⌘ ⌥ P : Open the pivot table wizard
fn ⇧ F11 : Insert new spreadsheet
Fn ⌃ ↓ : Go to the next worksheet
Fn ⌃ ↑ : Go to the previous worksheet
Fn F6 : Move to the next frame
Fn ⇧ F6 : Move to the previous frame
^ Tab : Go to the next workbook
^ ⇧ Tab : Go to the previous workbook
⌘ M : Minimize the current workbook window
fn ⌃ F10 : Maximize the current workbook window
⇧ Click : Select the adjacent worksheet
⌘ Click : Select a non-adjacent worksheet
Fn ⇧ F14 : Toggle scroll lock
^ ⌘ F : Enable full screen mode
⇧ Tab :Move to the previous control
⌃ Tab : Switch to the next tab
⌃ ⇧ Tab: Move to the previous tab
Return : Accept and apply
Space : Check and uncheck the box
Fn F7 : Open the Spelling dialog box
Fn ⇧ F7 : Open the Thesaurus dialog box
Fn ⌥ F8 : Open the Macro dialog box
Fn ⌥ F11 : Open the VBA editor
⌘ D: Duplicate object
⌘ : Shoot into the net
^ 6 : Hide or show objects
⌘ ⇧ L : Displays the Modify Cell Style dialog box
n ⇧ F10 : Displays the right-click menu
? : Displays the control menu