Keyboard Shortcuts for Google Spreadsheets

I have compiled essential keyboard shortcuts for, much preferred online spreadsheet application, Google Spreadsheets. This will come handy for those who depend heavily on Google spreadsheets for their business activities.

The list below, basically shows the shortcuts available with a PC, if you are a Mac user then you may safely replayce Ctrl with Command key and Alt with Option key.

Editing action
Undo             Ctrl + Z
Insert time         Ctrl + Shift + :
Insert date         Ctrl + Shift + ;
Fill range         Ctrl + Enter
Fill down         Ctrl + D
Fill right         Ctrl + R
Insert/edit comment     Shift + F2
Redo             Ctrl + Y
Edit a cell         F2 (Fn + F2 on a Mac)

Movement action
To start of row     Home
To beginning of sheet     Ctrl + Home
To end of row         End
To end of sheet     Ctrl + End
To next sheet         Ctrl + Shift + PageDown
To previous sheet     Ctrl + Shift + PageUp
Scroll to active cell     Ctrl + Backspace
Find & replace         Ctrl + F

Menus
Show context menu     Ctrl + Shift + \
Show sheet list     Alt + Shift + K
File menu         Alt + F
Display sheet menu     Alt + Shift + S

Formatting action
Bold             Ctrl + B
Underline         Ctrl + U
Italic     Ctrl + I
Strikethrough         Alt + Shift + 5
Apply outer border     Alt + Shift + 7
Remove borders         Alt + Shift + –
Apply top border     Alt + Shift + T
Apply bottom border     Alt + Shift + B
Apply left border     Alt + Shift + L
Apply right border     Alt + Shift + R
Format as currency     Ctrl + Shift + 4
Format as percentage     Ctrl + Shift + 5
Format as exponent     Ctrl + Shift + 6
Format as date         Ctrl + Shift + 3
Format as time         Ctrl + Shift + 2
Format as decimal     Ctrl + Shift + 1

Selection action
Select column         Ctrl + Space
Select row         Shift + Space
Select all         Ctrl + Shift + Space
Select active region     Ctrl + Shift + 8

Insertion action
Insert array formula     Ctrl + Shift + Enter
Add new sheet         Shift + F11

File commands
Save             Ctrl + S
Open             Ctrl + O
Make a copy         Ctrl + Shift + S
Print             Ctrl + P

View
Show all formulas     Ctrl + ~
Compact controls     Ctrl + Shift + F

Navigation
Chat             Shift + Esc

Help
Open documentation (new window) Shift + F1
Show shortcuts help pop-up     Ctrl + /
Enable ARIA/JAWS screenreader     Alt + Shift + ~

Leave a Reply

Your email address will not be published. Required fields are marked *