Hotkeys and shortcuts for Google Sheets (Mac)

(Total 107)

`Ctrl` + `Space`	Common actions Select column
`↑ Shift` + `Space`	Common actions Select row
`⌘ Cmd` + `A`	Common actions Select all
`⌘ Cmd` + `↑ Shift` + `Space`	Common actions %% Select all
`⌘ Cmd` + `Z`	Common actions Undo
`⌘ Cmd` + `Y`	Common actions Redo
`⌘ Cmd` + `↑ Shift` + `Z`	Common actions Redo
`Fn` + `F4`	Use formulas (when entering a formula) Absolute/relative references
`⌘ Cmd` + `F`	Common actions Find
`⌘ Cmd` + `↑ Shift` + `H`	Common actions Find and replace
`⌘ Cmd` + `⤶ Enter`	Common actions Fill range
`⌘ Cmd` + `D`	Common actions Fill down
`⌘ Cmd` + `R`	Common actions Fill right
`⌘ Cmd` + `S`	Common actions Save (every change is saved automatically in Drive)
`⌘ Cmd` + `O`	Common actions Open
`⌘ Cmd` + `P`	Common actions Print
`⌘ Cmd` + `C`	Common actions Copy
`⌘ Cmd` + `X`	Common actions Cut
`⌘ Cmd` + `V`	Common actions Paste
`⌘ Cmd` + `↑ Shift` + `V`	Common actions Paste values only
`⌘ Cmd` + `/`	Common actions Show common keyboard shortcuts
`Ctrl` + `↑ Shift` + `F`	Common actions Compact controls
`⌘ Cmd` + `↑ Shift` + `K`	Common actions Input tools on/off (available in spreadsheets in non-Latin languages)
`⌘ Cmd` + `⌥ Option` + `↑ Shift` + `K`	Common actions Select input tools
`⌘ Cmd` + `B`	Format cells Bold
`⌘ Cmd` + `U`	Format cells Underline
`⌘ Cmd` + `İ`	Format cells Italic
`⌥ Option` + `↑ Shift` + `5`	Format cells Strikethrough
`⌘ Cmd` + `↑ Shift` + `E`	Format cells Center align
`⌘ Cmd` + `↑ Shift` + `L`	Format cells Left align
`⌘ Cmd` + `↑ Shift` + `R`	Format cells Right align
`⌥ Option` + `↑ Shift` + `1`	Format cells Apply top border
`⌥ Option` + `↑ Shift` + `2`	Format cells Apply right border
`⌥ Option` + `↑ Shift` + `3`	Format cells Apply bottom border
`⌥ Option` + `↑ Shift` + `4`	Format cells Apply left border
`⌥ Option` + `↑ Shift` + `6`	Format cells Remove borders
`⌥ Option` + `↑ Shift` + `7`	Format cells Apply outer border
`⌘ Cmd` + `↑ Shift` + `7`	Format cells Apply outer border
`⌘ Cmd` + `K`	Format cells Insert link
`⌘ Cmd` + `↑ Shift` + `;`	Format cells Insert time
`⌘ Cmd` + `;`	Format cells Insert date
`⌘ Cmd` + `⌥ Option` + `↑ Shift` + `;`	Format cells Insert date and time
`Ctrl` + `↑ Shift` + `1`	Format cells Format as decimal
`Ctrl` + `↑ Shift` + `2`	Format cells Format as time
`Ctrl` + `↑ Shift` + `3`	Format cells Format as date
`Ctrl` + `↑ Shift` + `4`	Format cells Format as currency
`Ctrl` + `↑ Shift` + `5`	Format cells Format as percentage
`Ctrl` + `↑ Shift` + `6`	Format cells Format as exponent
`⌘ Cmd` + `\`	Format cells Clear formatting
`Fn` + `←`	Navigate spreadsheet Move to beginning of row
`⌘ Cmd` + `Fn` + `←`	Navigate spreadsheet Move to beginning of sheet
`Fn` + `→`	Navigate spreadsheet Move to end of row
`⌘ Cmd` + `Fn` + `→`	Navigate spreadsheet Move to end of sheet
`⌘ Cmd` + `⬅ Backspace`	Navigate spreadsheet Scroll to active cell
`⌘ Cmd` + `↑ Shift` + `Fn` + `↓`	Navigate spreadsheet Move to next sheet
`Ctrl` + `↑ Shift` + `Fn` + `↑`	Navigate spreadsheet Move to previous sheet
`⌥ Option` + `↑ Shift` + `K`	Navigate spreadsheet Display list of sheets
`⌥ Option` + `⤶ Enter`	Navigate spreadsheet Open hyperlink
`⌥ Option` + `↑ Shift` + `X`	Navigate spreadsheet Open Explore
`Ctrl` + `⌘ Cmd` + `↑ Shift` + `M`	Navigate spreadsheet Move focus out of spreadsheet
`⌥ Option` + `↑ Shift` + `Q`	Navigate spreadsheet Move to quicksum (when a range of cells is selected)
`Ctrl` + `⌘ Cmd` then `E` then `P`	Navigate spreadsheet Move focus to popup (for links, bookmarks, and images)
`Ctrl` + `⌘ Cmd` + `R`	Navigate spreadsheet Open drop-down menu on filtered cell
`⌘ Cmd` + `⌥ Option` + `↑ Shift` + `H`	Navigate spreadsheet Open revision history
`↑ Shift` + `Esc`	Navigate spreadsheet Close drawing editor
`⌘ Cmd` + `Esc`	Navigate spreadsheet Close drawing editor
`↑ Shift` + `F2`	Edit notes and comments Insert/edit note
`⌘ Cmd` + `⌥ Option` + `M`	Edit notes and comments Insert/edit comment
`⌘ Cmd` + `⌥ Option` + `↑ Shift` + `A`	Edit notes and comments Open comment discussion thread
`Ctrl` + `⌘ Cmd` then `E` then `C`	Edit notes and comments Enter current comment
`Ctrl` + `⌘ Cmd` then `N` then `C`	Edit notes and comments Move to next comment
`Ctrl` + `⌘ Cmd` then `P` then `C`	Edit notes and comments Move to previous comment
`Ctrl` + `⌥ Option` + `F`	Open a menu File menu
`Ctrl` + `⌥ Option` + `E`	Open a menu Edit menu
`Ctrl` + `⌥ Option` + `V`	Open a menu View menu
`Ctrl` + `⌥ Option` + `I`	Open a menu Insert menu
`Ctrl` + `⌥ Option` + `O`	Open a menu Format menu
`Ctrl` + `⌥ Option` + `D`	Open a menu Data menu
`Ctrl` + `⌥ Option` + `T`	Open a menu Tools menu
`⌘ Cmd` + `⌥ Option` + `=`	Insert, delete, hide, or unhide rows or columns (with columns selected) Insert columns to the left
`⌘ Cmd` + `⌥ Option` + `-`	Insert, delete, hide, or unhide rows or columns (with rows selected) Delete rows
`Ctrl` + `⌥ Option` + `M`	Open a menu Form menu
`Ctrl` + `⌥ Option` + `N`	Open a menu Add-ons menu
`Alt` + `H`	Open a menu (in Google Chrome) Help menu
`Alt` + `↑ Shift` + `H`	Open a menu (in other browsers) Help menu
`Ctrl` + `⌥ Option` + `A`	Open a menu (present when screen reader support is enabled) Accessibility menu
`⌥ Option` + `↑ Shift` + `S`	Open a menu Sheet menu (copy, delete, and other sheet actions)
`⌘ Cmd` + `↑ Shift` + `\`	Open a menu Context menu
`Ctrl` + `⌥ Option` + `I` then `R`	Insert, delete, hide, or unhide rows or columns (with rows selected) Insert rows above
`Ctrl` + `⌥ Option` + `I` then `B`	Insert, delete, hide, or unhide rows or columns Insert rows below
`Ctrl` + `⌥ Option` + `I` then `C`	Insert, delete, hide, or unhide rows or columns (with columns selected) Insert columns to the left
`Ctrl` + `⌥ Option` + `I` then `O`	Insert, delete, hide, or unhide rows or columns Insert columns to the right
`Ctrl` + `⌥ Option` + `E` then `D`	Insert, delete, hide, or unhide rows or columns (with rows selected) Delete rows
`Ctrl` + `⌥ Option` + `-`	Insert, delete, hide, or unhide rows or columns (with columns selected) Delete columns
`Ctrl` + `⌥ Option` + `E` then `E`	Insert, delete, hide, or unhide rows or columns (with columns selected) Delete columns
`⌘ Cmd` + `⌥ Option` + `9`	Insert, delete, hide, or unhide rows or columns Hide row
`⌘ Cmd` + `⌥ Option` + `0`	Insert, delete, hide, or unhide rows or columns Hide column
`Ctrl` + `~`	Use formulas Show all formulas
`⌘ Cmd` + `↑ Shift` + `⤶ Enter`	Use formulas Insert array formula
`⌘ Cmd` + `E`	Use formulas Collapse an expanded array formula
`↑ Shift` + `Fn` + `F1`	Use formulas (when entering a formula) Show/hide formula help
`Fn` + `F1`	Use formulas (when entering a formula) Full / compact formula help
`Fn` + `F9`	Use formulas (when entering a formula) Toggle formula result previews
`Ctrl` + `⌥ Option` + `↑ ↓`	Use formulas Resize formula bar
`⌘ Cmd` + `⌥ Option` + `Z`	Help for screen readers Turn on screen reader support
`⌘ Cmd` + `⌥ Option` + `↑ Shift` + `C`	Help for screen readers Read column
`⌘ Cmd` + `⌥ Option` + `↑ Shift` + `R`	Help for screen readers Read row

Hotkeys and shortcuts for Google Sheets (Mac)

(Total 107)

Ctrl + Space

Common actions

Select column

↑ Shift + Space

Common actions

Select row

⌘ Cmd + A

Common actions

Select all

⌘ Cmd + ↑ Shift + Space

Common actions

%% Select all

⌘ Cmd + Z

Common actions

Undo

⌘ Cmd + Y

Common actions

Redo

⌘ Cmd + ↑ Shift + Z

Common actions

Redo

Fn + F4

Use formulas

(when entering a formula) Absolute/relative references

⌘ Cmd + F

Common actions

Find

⌘ Cmd + ↑ Shift + H

Common actions

Find and replace

⌘ Cmd + ⤶ Enter

Common actions

Fill range

⌘ Cmd + D

Common actions

Fill down

⌘ Cmd + R

Common actions

Fill right

⌘ Cmd + S

Common actions

Save (every change is saved automatically in Drive)

⌘ Cmd + O

Common actions

Open

⌘ Cmd + P

Common actions

Print

⌘ Cmd + C

Common actions

Copy

⌘ Cmd + X

Common actions

Cut

⌘ Cmd + V

Common actions

Paste

⌘ Cmd + ↑ Shift + V

Common actions

Paste values only

⌘ Cmd + /

Common actions

Show common keyboard shortcuts

Ctrl + ↑ Shift + F

Common actions

Compact controls

⌘ Cmd + ↑ Shift + K

Common actions

Input tools on/off (available in spreadsheets in non-Latin languages)

⌘ Cmd + ⌥ Option + ↑ Shift + K

Common actions

Select input tools

⌘ Cmd + B

Format cells

Bold

⌘ Cmd + U

Format cells

Underline

`Ctrl` + `Space`

`↑ Shift` + `Space`

`⌘ Cmd` + `A`

`⌘ Cmd` + `↑ Shift` + `Space`

`⌘ Cmd` + `Z`

`⌘ Cmd` + `Y`

`⌘ Cmd` + `↑ Shift` + `Z`

`Fn` + `F4`

`⌘ Cmd` + `F`

`⌘ Cmd` + `↑ Shift` + `H`

`⌘ Cmd` + `⤶ Enter`

`⌘ Cmd` + `D`

`⌘ Cmd` + `R`

`⌘ Cmd` + `S`

`⌘ Cmd` + `O`

`⌘ Cmd` + `P`

`⌘ Cmd` + `C`

`⌘ Cmd` + `X`

`⌘ Cmd` + `V`

`⌘ Cmd` + `↑ Shift` + `V`

`⌘ Cmd` + `/`

`Ctrl` + `↑ Shift` + `F`

`⌘ Cmd` + `↑ Shift` + `K`

`⌘ Cmd` + `⌥ Option` + `↑ Shift` + `K`

`⌘ Cmd` + `B`

`⌘ Cmd` + `U`

`⌘ Cmd` + `İ`

`⌥ Option` + `↑ Shift` + `5`

`⌘ Cmd` + `↑ Shift` + `E`

`⌘ Cmd` + `↑ Shift` + `L`

`⌘ Cmd` + `↑ Shift` + `R`

`⌥ Option` + `↑ Shift` + `1`

`⌥ Option` + `↑ Shift` + `2`

`⌥ Option` + `↑ Shift` + `3`

`⌥ Option` + `↑ Shift` + `4`

`⌥ Option` + `↑ Shift` + `6`

`⌥ Option` + `↑ Shift` + `7`

`⌘ Cmd` + `↑ Shift` + `7`

`⌘ Cmd` + `K`

`⌘ Cmd` + `↑ Shift` + `;`

`⌘ Cmd` + `;`

`⌘ Cmd` + `⌥ Option` + `↑ Shift` + `;`

`Ctrl` + `↑ Shift` + `1`

`Ctrl` + `↑ Shift` + `2`

`Ctrl` + `↑ Shift` + `3`

`Ctrl` + `↑ Shift` + `4`

`Ctrl` + `↑ Shift` + `5`

`Ctrl` + `↑ Shift` + `6`

`⌘ Cmd` + `\`

`Fn` + `←`