Google Sheets keyboard shortcuts 

Google Sheets    

Zeynel -
7 years ago
- Shortcuts
0
Ctrl + O

Open

0
Ctrl + C

Copy

0
Ctrl + Z

Undo

0
Ctrl + A

Select all

-1
Ctrl + F

Find

0
Ctrl + P

Print

0
Ctrl + Y

Redo

0
or F4
0
or Ctrl + ↑  Shift + Z
0
Ctrl + ↑  Shift + Space

Select all

0
Ctrl + V

Paste

0
Ctrl + X

Cut

-1
Ctrl + B

Bold

1
Ctrl + U

Underline

0
Ctrl + H

Find and replace

0
Ctrl + K

Insert link

0
Ctrl + Space

Select column

0
Ctrl + ↑  Shift + R

Right align

0
Ctrl + ↑  Shift + L

Left align

-1
Ctrl + ↑  Shift + E

Center align

-1
↑  Shift + Space

Select row

0
Ctrl + \

Clear formatting

0
Ctrl + ↑  Shift + \

Context menu

0
Alt + ↑  Shift + 5

Strikethrough

0
Ctrl + İ

Italic

1
Ctrl + S

Save (every change is saved automatically in Drive)

0
Ctrl + D

Fill down

0
Ctrl + R

Fill right

0
F4

(when entering a formula) Absolute/relative references

0
Ctrl + E

Collapse an expanded array formula

0
F9

(when entering a formula) Toggle formula result previews

0
Home

Move to beginning of row

0
End

Move to end of row

1
Ctrl + ⤶ Enter

Fill range

-1
Ctrl + ↑  Shift + F

Compact controls

0
Ctrl + ↑  Shift + V

Paste values only

0
Alt + ⤶ Enter

Open hyperlink

0
Ctrl + Home

Move to beginning of sheet

0
Ctrl + End

Move to end of sheet

1
Ctrl + /

Show common keyboard shortcuts

0
Ctrl + ↑  Shift + K

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

1
Ctrl + Backspace

Scroll to active cell

0
Alt + A

(in Google Chrome) Accessibility menu

0
Alt + D

Data menu (in Google Chrome)

0
Alt + F

(in Google Chrome) File menu

0
↑  Shift + F2

Insert/edit note

0
Alt + O

Format menu (in Google Chrome)

0
Alt + E

(in Google Chrome) Edit menu

0
Alt + T

Tools menu  (in Google Chrome)

0
Alt + N

(in Google Chrome) Add-ons menu

1
Ctrl + Alt + R

Open drop-down menu on filtered cell

0
Alt + I

(in Google Chrome) Insert menu

0
↑  Shift + F1

(when entering a formula) Show/hide formula help

0
Alt + M

(in Google Chrome)  Form menu

0
Alt + H

(in Google Chrome) Help menu

-1
Ctrl + Alt + M

Insert/edit comment

0
↑  Shift + F11

Insert new sheet

0
Ctrl + ↑  Shift + ⤶ Enter

Insert array formula

0
Alt + V

(in Google Chrome) View menu

Advertisement

0
Ctrl + ↑  Shift + 1

Format as decimal

0
Ctrl +   

Resize formula bar

0
Ctrl + ↑  Shift + 2

Format as time

0
Alt + ↑  Shift + S

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

0
↑  Shift + Esc

Open chat inside the spreadsheet

0
↑  Shift + Esc

Close drawing editor

0
Alt + ↑  Shift + T

(in other browsers)

0
Ctrl + ↑  Shift + 3

Format as date

0
Ctrl + ↑  Shift + 7

Apply outer border

0
Ctrl + ;

Insert date

0
Alt + ↑  Shift + D

(in other browsers)

0
Alt + ↑  Shift + A

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

0
Ctrl + Shift + Page Down

Move to next sheet

0
Ctrl + Shift + Page Up

Move to previous sheet

0
Ctrl + Alt + 0

Hide column

0
Ctrl + ↑  Shift + 6

Format as exponent

0
Alt + ↑  Shift + F

(in other browsers) File menu

0
Ctrl + ↑  Shift + 4

Format as currency

-1
Alt + ↑  Shift + V

View menu (in other browsers)

0
Ctrl + ↑  Shift + 5

Format as percentage

0
Ctrl + Alt + Z

Turn on screen reader support

0
Ctrl + ↑  Shift + 9

Unhide row

0
Alt + ↑  Shift + M

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

0
Alt + ↑  Shift + O

(in other browsers) Format menu

0
Alt + ↑  Shift + N

(in other browsers) Add-ons menu

0
Ctrl + ↑  Shift + 0

Unhide column

0
Alt + ↑  Shift + 1

Apply top border

0
Alt + ↑  Shift + H

(in other browsers) Help menu

0
Ctrl + Alt + ↑  Shift + C

Read column

0
Alt + ↑  Shift + E

(in other browsers) Edit menu

0
Ctrl + Alt + ↑  Shift + R

Read row

1
Ctrl + Alt + -

(with cells selected)  Open delete menu

0
Ctrl + Alt + -

(with rows selected) Delete rows

0
Ctrl + Alt + -

(with columns selected)  Delete columns

0
Alt + ↑  Shift + 3

Apply bottom border

1
Ctrl + Alt + ↑  Shift + H

Open revision history

0
Alt + ↑  Shift + K

Display list of sheets

0
Alt + ↑  Shift + X

Open Explore

0
Alt + ↑  Shift + 2

Apply right border

0
Alt + ↑  Shift + Q

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

2
Ctrl + ↑  Shift + ;

Insert time

0
Alt + ↑  Shift + 4

Apply left border

0
Ctrl + Alt + ↑  Shift + M

Move focus out of spreadsheet

0
Ctrl + Alt + 9

Hide row

0
Ctrl + Alt + =

(with cells selected) Open insert menu

1
Ctrl + Alt + =

(with rows selected) Insert rows above

0
Ctrl + Alt + =

(with columns selected) Insert columns to the left

0
Ctrl + Alt + ↑  Shift + A

Open comment discussion thread

-1
Alt + ↑  Shift + 6

Remove borders

0
Alt + ↑  Shift + 7

Apply outer border

0
Ctrl + Alt + ↑  Shift + K

Select input tools

0
Ctrl + ~

Show all formulas

0
Ctrl + Alt + ↑  Shift + =

(with cells selected) Open insert menu

-1
Ctrl + Alt + ↑  Shift + =

(with rows selected) Insert rows above

0
Ctrl + Alt + ↑  Shift + =

(with columns selected) Insert columns to the left

1
Ctrl + Alt + ↑  Shift + ;

Insert date and time

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
Alt + ↑  Shift + İ

(in other browsers) Insert menu

0
Alt + I then R

(in Google Chrome) Insert rows above

1
Alt + ↑  Shift + I then R

(in other browsers) Insert rows above

0
Alt + I then W

(in Google Chrome) Insert rows below

0
Alt + ↑  Shift + I then W

(in other browsers) Insert rows below

0
Alt + I then C

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

0
Alt + ↑  Shift + I then C

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

0
Alt + I then O

(in Google Chrome) Insert columns to the right

0
Alt + ↑  Shift + I then O

(in other browsers) Insert columns to the right

0
Alt + E then D

(in Google Chrome, with rows selected) Delete rows

0
Alt + ↑  Shift + E then D

(in other browsers, with rows selected) Delete rows

0
Alt + E then E

(in Google Chrome, with columns selected) Delete columns

0
or Alt + ↑  Shift + E then E

Advertisement


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: 07/03/2020 08: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