Google Sheets: keyboard shortcuts and common actions

Use keyboard shortcuts in Google sheets to navigate, format, and use formulas in your spreadsheet. To see a list of keyboard shortcuts in Google Sheets, press Ctrl + / (Windows, Chrome OS) or ⌘ + /(Mac).

Note: Some shortcuts might not work for all languages or keyboards.

Common actions for PCs, (for Macs use ⌘ instead of Ctrl)

Select column

Ctrl + Space

Select row

Shift + Space

Select all

Ctrl + a

Undo

Ctrl + z

Redo

Ctrl + y

Ctrl + Shift + z

Find

Ctrl + f

Find and replace

Ctrl + h

Fill range

Ctrl + Enter

Fill down

Ctrl + d

Fill right

Ctrl + r

Save

(every change is saved automatically in Drive)

Ctrl + s

Open

Ctrl + o

Print

Ctrl + p

Copy

Ctrl + c

Cut

Ctrl + x

Paste

Ctrl + v

Paste values only

Ctrl + Shift + v

Show common keyboard shortcuts

Ctrl + /

Compact controls

Ctrl + Shift + f

Input tools on/off

(available in spreadsheets in non-Latin languages)

Ctrl + Shift + k

Select input tools

Ctrl + Alt + Shift + k

External Resources

  • Full list of Goolge Sheet keyboard shortcuts - https://support.google.com/docs/answer/181110?co=GENIE.Platform%3DDesktop&hl=en

 

 

 

Details

Article ID: 75760
Created
Wed 4/10/19 8:21 AM
Modified
Thu 4/11/19 11:32 AM