Google Sheets keyboard shortcuts 

Google Sheets    

Zeynel -
7 years ago
- Shortcuts

Advertisement

0
Alt + ↑  Shift + E then E

(in Google Chrome, with columns selected) Delete columns

1
Alt + ↑  Shift + I then R

(in other browsers) Insert rows above

0
Alt + ↑  Shift + I then W

(in other browsers) Insert rows below

0
Alt + ↑  Shift + I then C

(in other browsers, with columns selected) Insert columns to the left

0
Alt + ↑  Shift + I then O

(in other browsers) Insert columns to the right

0
Alt + ↑  Shift + E then D

(in other browsers, with rows selected) Delete rows

0
Alt + I then O

(in Google Chrome) Insert columns to the right

0
Alt + I then R

(in Google Chrome) Insert rows above

0
Alt + I then C

(in Google Chrome, with columns selected) Insert columns to the left

0
Alt + I then W

(in Google Chrome) Insert rows below

0
Alt + E then D

(in Google Chrome, with rows selected) Delete rows

0
Alt + E then E

(in Google Chrome, with columns selected) Delete columns

0
Ctrl + Alt + ↑  Shift + C

Read column

0
Ctrl + Alt + ↑  Shift + R

Read row

0
Ctrl + Alt + ↑  Shift + A

Open comment discussion thread

0
Alt + ↑  Shift + İ

(in other browsers) Insert menu

1
Ctrl + Alt + -

(with cells selected)  Open delete menu

0
Ctrl + Alt + -

(with columns selected)  Delete columns

0
Ctrl + Alt + -

(with rows selected) Delete rows

0
Ctrl + Alt + ↑  Shift + =

(with columns selected) Insert columns to the left

-1
Ctrl + Alt + ↑  Shift + =

(with rows selected) Insert rows above

0
Ctrl + Alt + ↑  Shift + =

(with cells selected) Open insert menu

1
Ctrl + Alt + ↑  Shift + ;

Insert date and time

0
Ctrl + Alt + ↑  Shift + K

Select input tools

0
Ctrl + Alt then E then P

Move focus to popup (for links, bookmarks, and images)

0
Ctrl + Alt then E then C

Enter current comment

0
Ctrl + Alt then N then C

Move to next comment

0
Ctrl + Alt then P then C

Move to previous comment

0
Ctrl + ↑  Shift + \

Context menu

0
Ctrl + Alt + ↑  Shift + M

Move focus out of spreadsheet

0
Ctrl + İ

Italic

0
Alt + ↑  Shift + 5

Strikethrough

0
Alt + ↑  Shift + Q

Move to quicksum (when a range of cells is selected)

1
Ctrl + Alt + R

Open drop-down menu on filtered cell

0
Ctrl + \

Clear formatting

1
Ctrl + Backspace

Scroll to active cell

0
Alt + ↑  Shift + 1

Apply top border

0
Alt + ↑  Shift + 2

Apply right border

0
Alt + ↑  Shift + 3

Apply bottom border

0
Alt + ↑  Shift + 4

Apply left border

0
Ctrl + Alt + Z

Turn on screen reader support

0
Alt + ↑  Shift + X

Open Explore

0
Alt + ↑  Shift + F

(in other browsers) File menu

0
Alt + ↑  Shift + E

(in other browsers) Edit menu

0
Alt + ↑  Shift + D

(in other browsers)

0
Alt + ↑  Shift + A

(in other browsers. Present when screen reader support is enabled)  Accessibility menu

0
Alt + ↑  Shift + S

Sheet menu (copy, delete, and other sheet actions)

0
Ctrl + P

Print

1
Ctrl + Alt + ↑  Shift + H

Open revision history

0
Ctrl + ;

Insert date

-1
Alt + ↑  Shift + 6

Remove borders

Advertisement

0
Alt + ↑  Shift + 7

Apply outer border

0
Alt + D

Data menu (in Google Chrome)

0
Alt + E

(in Google Chrome) Edit menu

0
Alt + F

(in Google Chrome) File menu

0
Alt + A

(in Google Chrome) Accessibility menu

0
Ctrl + O

Open

0
Ctrl + ↑  Shift + Space

Select all

0
Ctrl + ↑  Shift + K

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

1
Ctrl + /

Show common keyboard shortcuts

0
Ctrl + ↑  Shift + 7

Apply outer border

0
Ctrl + ↑  Shift + 6

Format as exponent

0
Ctrl + ↑  Shift + L

Left align

2
Ctrl + ↑  Shift + ;

Insert time

0
Ctrl + Shift + Page Down

Move to next sheet

0
Ctrl + Shift + Page Up

Move to previous sheet

0
Alt + ↑  Shift + K

Display list of sheets

1
Ctrl + Alt + =

(with rows selected) Insert rows above

0
Ctrl + Alt + =

(with columns selected) Insert columns to the left

0
Ctrl + ↑  Shift + ⤶ Enter

Insert array formula

0
Ctrl + Alt + 9

Hide row

0
Ctrl + Alt + 0

Hide column

0
Ctrl + ↑  Shift + 9

Unhide row

0
Ctrl + ↑  Shift + 0

Unhide column

0
Alt + ↑  Shift + O

(in other browsers) Format menu

0
Ctrl + Alt + =

(with cells selected) Open insert menu

0
Alt + ↑  Shift + T

(in other browsers)

0
Alt + ↑  Shift + H

(in other browsers) Help menu

0
Alt + ↑  Shift + M

(other browsers. Present when the spreadsheet is connected to a form) Form menu

0
Alt + ↑  Shift + N

(in other browsers) Add-ons menu

-1
Ctrl + Alt + M

Insert/edit comment

0
Alt + O

Format menu (in Google Chrome)

-1
Alt + ↑  Shift + V

View menu (in other browsers)

0
Alt + I

(in Google Chrome) Insert menu

0
Alt + ⤶ Enter

Open hyperlink

0
Ctrl + End

Move to end of sheet

0
Ctrl + Home

Move to beginning of sheet

0
↑  Shift + Esc

Open chat inside the spreadsheet

0
↑  Shift + Esc

Close drawing editor

1
Ctrl + U

Underline

0
Ctrl + ↑  Shift + R

Right align

-1
Ctrl + ↑  Shift + E

Center align

0
Ctrl + ↑  Shift + 1

Format as decimal

0
Ctrl + ↑  Shift + 2

Format as time

0
Ctrl + ↑  Shift + 3

Format as date

0
Ctrl + ↑  Shift + 4

Format as currency

0
Ctrl + ↑  Shift + 5

Format as percentage

0
Ctrl + K

Insert link

0
↑  Shift + F11

Insert new sheet

-1
Ctrl + ↑  Shift + F

Compact controls

0
Ctrl + ↑  Shift + V

Paste values only

1
Ctrl + ⤶ Enter

Fill range

0
Ctrl + Space

Select column

-1
↑  Shift + Space

Select row

0
Ctrl + ↑  Shift + Z

Redo

0
Ctrl +   

Resize formula bar

0
Ctrl + ~

Show all formulas

0
Ctrl + E

Collapse an expanded array formula

0
↑  Shift + F1

(when entering a formula) Show/hide formula help

0
F4

(when entering a formula) Absolute/relative references

0
F9

(when entering a formula) Toggle formula result previews

0
Alt + V

(in Google Chrome) View menu

0
Alt + H

(in Google Chrome) Help menu

0
Alt + N

(in Google Chrome) Add-ons menu

0
Alt + M

(in Google Chrome)  Form menu

0
Alt + T

Tools menu  (in Google Chrome)

0
F4

Redo

-1
Ctrl + F

Find

0
Ctrl + H

Find and replace

0
Ctrl + A

Select all

0
Ctrl + D

Fill down

0
Ctrl + R

Fill right

1
Ctrl + S

Save (every change is saved automatically in Drive)

0
Ctrl + C

Copy

0
Ctrl + X

Cut

0
Ctrl + V

Paste

0
Ctrl + Z

Undo

0
Ctrl + Y

Redo

0
Home

Move to beginning of row

-1
Ctrl + B

Bold

0
↑  Shift + F2

Insert/edit note

0
End

Move to end of row


Share this page on:
Is this page helpful?
1 0

Program information

Program name: Google Sheets Google Sheets (Productivity)

Web page: google.com/sheets

Last update: 7/3/2020 8:19 UTC

How easy to press shortcuts: 65%

More information >>

Shortcut count: 132

Platform detected: Windows or Linux

Similar programs



User operations

Add Google Sheets to your list of favorites

Advertisement


What is your favorite Google Sheets hotkey? Do you have any useful tips for it? Let other users know below.


Only registered users can post links.
 
No comments yet. Ask, or type the first one!

Latest articles