Google Sheets

Insert, delete, hide, or unhide rows or columns

(in other browsers) Insert rows below

Alt + ↑   Shift + I then W

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

Similar combinations for other applications