Google Sheets keyboard shortcuts

Google Sheets  

Zeynel -
6 years ago
- Shortcuts

Frequent Google Sheets users will want to use some shortcuts, because they're quite powerful.

0
Ctrl + Space

Select column

0
Ctrl + H

Find and replace

1
Ctrl + ⤶ Enter

Fill range

0
Ctrl + D

Fill down

1
Ctrl + ↑  Shift + V

Paste values only

Advertisement

1
Ctrl + U

Underline

0
Alt + ↑  Shift + 5

Strikethrough

0
Alt + ↑  Shift + 2

Apply right border

2
Ctrl + ↑  Shift + ;

Insert time

0
Ctrl + ;

Insert date

1
Ctrl + Alt + ↑  Shift + ;

Insert date and time

0
Alt + ↑  Shift + X

Open Explore

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

1
Ctrl + Alt + ↑  Shift + H

Open revision history

1
Ctrl + Alt + -

(with cells selected)  Open delete menu

0
Alt + ↑  Shift + N

(in other browsers) Add-ons menu

1
Ctrl + Alt + =

(with rows selected) Insert rows above

1
Alt + I then R

(in Google Chrome) Insert rows above

1
Alt + ↑  Shift + I then R

(in other browsers) Insert rows above


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

Program information

Program name: Google Sheets Google Sheets (Productivity)

Google Sheets is a spreadsheet program developed by Google. Its offered in Google Drive service, together with Docs and Slides. Sheets allows users to create and edit files online while collaboration with other users in real time.

Web page: google.com/sheets

Last update: 3/7/2020 8:19 AM 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 favorites

Add to favorites

Advertisement


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


 
No comments yet. Ask, or type the first one!