Google Sheets (Mac)

Insert, delete, hide, or unhide rows or columns

Insert rows below

`Ctrl` + `⌥ Option` + `I` then `B`

All hotkeys for Google Sheets (Mac)

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

Google Sheets (Mac)

Insert, delete, hide, or unhide rows or columns

Insert rows below

Ctrl + ⌥ Option + I then B

All hotkeys for Google Sheets (Mac)

Common actions

Select column

Ctrl + Space

Common actions

Select row

↑ Shift + Space

Common actions

Select all

⌘ Cmd + A

Common actions

%% Select all

⌘ Cmd + ↑ Shift + Space

Common actions

Undo

⌘ Cmd + Z

Common actions

Redo

⌘ Cmd + Y

Common actions

Redo

⌘ Cmd + ↑ Shift + Z

Use formulas

(when entering a formula) Absolute/relative references

Fn + F4

Common actions

Find

⌘ Cmd + F

Common actions

Find and replace

⌘ Cmd + ↑ Shift + H

Common actions

Fill range

⌘ Cmd + ⤶ Enter

Common actions

Fill down

⌘ Cmd + D

Common actions

Fill right

⌘ Cmd + R

Common actions

Save (every change is saved automatically in Drive)

⌘ Cmd + S

Common actions

Open

⌘ Cmd + O

Common actions

Print

⌘ Cmd + P

Common actions

Copy

⌘ Cmd + C

Common actions

Cut

⌘ Cmd + X

Common actions

Paste

⌘ Cmd + V

Common actions

Paste values only

⌘ Cmd + ↑ Shift + V

Common actions

Show common keyboard shortcuts

⌘ Cmd + /

Common actions

Compact controls

Ctrl + ↑ Shift + F

Common actions

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

⌘ Cmd + ↑ Shift + K

Common actions

Select input tools

⌘ Cmd + ⌥ Option + ↑ Shift + K

Format cells

Bold

⌘ Cmd + B

`Ctrl` + `⌥ Option` + `I` then `B`

`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`