Google Sheets

Insert, delete, hide, or unhide rows or columns

(in other browsers) Insert rows above

`Alt` + `↑ Shift` + `I` then `R`

All hotkeys for Google Sheets

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

Google Sheets

Insert, delete, hide, or unhide rows or columns

(in other browsers) Insert rows above

Alt + ↑ Shift + I then R

All hotkeys for Google Sheets

Common actions

Select column

Ctrl + Space

Common actions

Select row

↑ Shift + Space

Common actions

Select all

Ctrl + A

Common actions

Select all

Ctrl + ↑ Shift + Space

Common actions

Undo

Ctrl + Z

Common actions

Redo

Ctrl + Y

Common actions

Redo

Ctrl + ↑ Shift + Z

Use formulas

(when entering a formula) Absolute/relative references

F4

Common actions

Find

Ctrl + F

Common actions

Find and replace

Ctrl + H

Common actions

Fill range

Ctrl + ⤶ Enter

Common actions

Fill down

Ctrl + D

Common actions

Fill right

Ctrl + R

Common actions

Save (every change is saved automatically in Drive)

Ctrl + S

Common actions

Open

Ctrl + O

Common actions

Print

Ctrl + P

Common actions

Copy

Ctrl + C

Common actions

Cut

Ctrl + X

Common actions

Paste

Ctrl + V

Common actions

Paste values only

Ctrl + ↑ Shift + V

Common actions

Show common keyboard shortcuts

Ctrl + /

Common actions

Insert new sheet

↑ Shift + F11

Common actions

Compact controls

Ctrl + ↑ Shift + F

Common actions

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

Ctrl + ↑ Shift + K

Common actions

Select input tools

Ctrl + Alt + ↑ Shift + K

`Alt` + `↑ Shift` + `I` then `R`

`Ctrl` + `Space`

`↑ Shift` + `Space`

`Ctrl` + `A`

`Ctrl` + `↑ Shift` + `Space`

`Ctrl` + `Z`

`Ctrl` + `Y`

`Ctrl` + `↑ Shift` + `Z`

`F4`

`Ctrl` + `F`

`Ctrl` + `H`

`Ctrl` + `⤶ Enter`

`Ctrl` + `D`

`Ctrl` + `R`

`Ctrl` + `S`

`Ctrl` + `O`

`Ctrl` + `P`

`Ctrl` + `C`

`Ctrl` + `X`

`Ctrl` + `V`

`Ctrl` + `↑ Shift` + `V`

`Ctrl` + `/`

`↑ Shift` + `F11`

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

`Ctrl` + `↑ Shift` + `K`

`Ctrl` + `Alt` + `↑ Shift` + `K`

`Ctrl` + `B`

`Ctrl` + `U`

`Ctrl` + `İ`

`Alt` + `↑ Shift` + `5`

`Ctrl` + `↑ Shift` + `E`

`Ctrl` + `↑ Shift` + `L`

`Ctrl` + `↑ Shift` + `R`

`Alt` + `↑ Shift` + `1`

`Alt` + `↑ Shift` + `2`

`Alt` + `↑ Shift` + `3`

`Alt` + `↑ Shift` + `4`

`Alt` + `↑ Shift` + `6`

`Alt` + `↑ Shift` + `7`

`Ctrl` + `↑ Shift` + `7`

`Ctrl` + `K`

`Ctrl` + `↑ Shift` + `;`

`Ctrl` + `;`

`Ctrl` + `Alt` + `↑ Shift` + `;`

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

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

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

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

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