Google Sheets (Mac) keyboard shortcuts

Google Sheets (Mac)  

Zeynel Öztürk -
6 years ago
- Shortcuts

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

-1
Ctrl + Space

Select column

0
↑  Shift + Space

Select row

0
⌘ Cmd + A

Select all

3
Fn + F4

Redo

0
⌘ Cmd + ⤶ Enter

Fill range

0
⌘ Cmd + R

Fill right

0
⌘ Cmd + ↑  Shift + V

Paste values only

Advertisement

0
⌘ Cmd + ↑  Shift + R

Right align

1
⌥ Opt + ↑  Shift + 4

Apply left border

1
⌥ Opt + ↑  Shift + 7

Apply outer border

0
⌘ Cmd + K

Insert link

0
⌘ Cmd + ;

Insert date

0
Ctrl + ↑  Shift + 6

Format as exponent

0
⌘ Cmd + Fn +

Move to beginning of sheet

1
Ctrl + ⌥ Opt + I then R

(with rows selected) Insert rows above

1
⌘ Cmd + ⌥ Opt + -

(with rows selected) Delete rows

0
Ctrl + ~

Show all formulas

2
Fn + F1

(when entering a formula) Full / compact formula help

5
Fn + F4

(when entering a formula) Absolute/relative references

0
Fn + F9

(when entering a formula) Toggle formula result previews


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

Program information

Program name: Google Sheets (Mac) Google Sheets (Mac) (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: 1/17/2020 6:52 AM UTC

How easy to press shortcuts: 67%

More information >>

Shortcut count: 115

Platform detected: Windows and macOS mixed

Similar programs




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


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