Google Sheets (Mac) keyboard shortcuts 

Google Sheets (Mac)    

Zeynel -
7 years ago
- Shortcuts
0
Ctrl + ↑  Shift + F

Compact controls

‎-1
Ctrl + Space

Select column

0
⌘ Cmd + C

Copy

0
⌘ Cmd + Z

Undo

0
⌘ Cmd + V

Paste

0
⌘ Cmd + S

Save (every change is saved automatically in Drive)

0
⌘ Cmd + F

Find

0
⌘ Cmd + A

Select all

0
⌘ Cmd + D

Fill down

0
⌘ Cmd + B

Bold

‎-1
↑  Shift + Space

Select row

‎-2
⌘ Cmd + ↑  Shift + Z

Redo

0
⌘ Cmd + X

Cut

0
↑  Shift + F2

Insert/edit note

0
⌘ Cmd + E

Collapse an expanded array formula

0
⌘ Cmd + K

Insert link

0
⌘ Cmd + R

Fill right

0
⌘ Cmd + O

Open

0
⌘ Cmd + ⤶ Enter

Fill range

0
Alt + H

(in Google Chrome) Help menu

0
⌘ Cmd + U

Underline

0
⌘ Cmd + ↑  Shift + L

Left align

0
⌘ Cmd + P

Print

0
Ctrl + ↑  Shift + 1

Format as decimal

‎-2
⌘ Cmd + /

Show common keyboard shortcuts

0
⌘ Cmd + ↑  Shift + R

Right align

0
⌘ Cmd + Y

Redo

0
⌘ Cmd + ↑  Shift + E

Center align

0
Ctrl + ↑  Shift + 2

Format as time

0
↑  Shift + Esc

Open chat inside the spreadsheet

0
↑  Shift + Esc

Close drawing editor

0
⌘ Cmd + ↑  Shift + V

Paste values only

0
⌘ Cmd + ↑  Shift + H

Find and replace

‎-1
Ctrl + ↑  Shift + 3

Format as date

0
⌘ Cmd + ↑  Shift + K

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

0
Ctrl + ↑  Shift + 6

Format as exponent

0
Ctrl + ↑  Shift + 4

Format as currency

0
Ctrl + ↑  Shift + 5

Format as percentage

0
⌘ Cmd + \

Clear formatting

0
⌘ Cmd + ⌥ Opt + M

Insert/edit comment

0
Alt + ↑  Shift + H

(in other browsers) Help menu

0
Fn +

Move to beginning of row

0
⌘ Cmd + ;

Insert date

0
Fn +

Move to end of row

0
⌘ Cmd + Backspace

Scroll to active cell

0
⌥ Opt + ⤶ Enter

Open hyperlink

0
Fn + F9

(when entering a formula) Toggle formula result previews

0
⌘ Cmd + ↑  Shift + ⤶ Enter

Insert array formula

0
⌘ Cmd + ⌥ Opt + 0

Hide column

0
⌘ Cmd + ↑  Shift + 7

Apply outer border

0
⌘ Cmd + ↑  Shift + \

Context menu

2
Fn + F1

(when entering a formula) Full / compact formula help

5
Fn + F4

(when entering a formula) Absolute/relative references

3
Fn + F4

Redo

0
⌥ Opt + ↑  Shift + S

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

‎-1
⌘ Cmd + ⌥ Opt + Z

Turn on screen reader support

0
⌘ Cmd + ⌥ Opt + ↑  Shift + C

Read column

0
Ctrl + ~

Show all formulas

0
⌘ Cmd + ↑  Shift + Space

Select all

Advertisement

0
⌘ Cmd + ⌥ Opt + ↑  Shift + H

Open revision history

0
⌘ Cmd + ⌥ Opt + ↑  Shift + A

Open comment discussion thread

0
⌘ Cmd + ⌥ Opt + 9

Hide row

0
⌘ Cmd + ⌥ Opt + ↑  Shift + R

Read row

0
⌘ Cmd + ⌥ Opt + ↑  Shift + K

Select input tools

0
⌥ Opt + ↑  Shift + 5

Strikethrough

0
⌥ Opt + ↑  Shift + 3

Apply bottom border

0
⌘ Cmd + Esc

Close drawing editor

0
⌘ Cmd + ↑  Shift + ;

Insert time

0
⌥ Opt + ↑  Shift + 1

Apply top border

0
⌘ Cmd + ⌥ Opt + =

(with cells selected) Open insert menu

0
⌘ Cmd + ⌥ Opt + -

(with cells selected)  Open delete menu

0
⌘ Cmd + ⌥ Opt + =

(with rows selected) Insert rows above

0
⌘ Cmd + ⌥ Opt + =

(with columns selected) Insert columns to the left

0
⌘ Cmd + ⌥ Opt + -

(with rows selected) Delete rows

1
or ⌘ Cmd + ⌥ Opt + -
0
⌥ Opt + ↑  Shift + 2

Apply right border

0
⌥ Opt + ↑  Shift + X

Open Explore

1
⌥ Opt + ↑  Shift + 4

Apply left border

0
⌥ Opt + ↑  Shift + 6

Remove borders

1
⌥ Opt + ↑  Shift + 7

Apply outer border

0
⌘ Cmd + Fn +

Move to end of sheet

0
⌘ Cmd + Fn +

Move to beginning of sheet

0
⌥ Opt + ↑  Shift + Q

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

0
⌥ Opt + ↑  Shift + K

Display list of sheets

0
Ctrl + ⌥ Opt + V

View menu

0
↑  Shift + Fn + F1

(when entering a formula) Show/hide formula help

0
Ctrl + ⌥ Opt + M

Form menu

0
Ctrl + ⌥ Opt + N

Add-ons menu

0
Ctrl + ⌥ Opt + D

Data menu

0
Ctrl + ⌥ Opt + T

Tools menu

0
Ctrl + ⌥ Opt + A

Accessibility menu

0
Ctrl + ⌥ Opt + A

(present when screen reader support is enabled) Accessibility menu

0
Ctrl + ⌥ Opt + I

Insert menu

0
Ctrl + ⌥ Opt + O

Format menu

0
Ctrl + ⌥ Opt + F

File menu

0
Ctrl + ⌥ Opt + E

Edit menu

0
Ctrl + ⌘ Cmd + R

Open drop-down menu on filtered cell

0
⌘ Cmd + İ

Italic

0
Ctrl + ⌘ Cmd then E then P

Move focus to popup (for links, bookmarks, and images)

0
Ctrl + ⌘ Cmd + ↑  Shift + M

Move focus out of spreadsheet

0
⌘ Cmd + ↑  Shift + Fn +

Move to next sheet

0
Ctrl + ↑  Shift + Fn +

Move to previous sheet

‎-3
⌘ Cmd + ⌥ Opt + ↑  Shift + ;

Insert date and time

0
Ctrl + ⌘ Cmd then E then C

Enter current comment

0
Ctrl + ⌘ Cmd then N then C

Move to next comment

0
Ctrl + ⌘ Cmd then P then C

Move to previous comment

1
Ctrl + ⌥ Opt + I then R

(with rows selected) Insert rows above

0
Ctrl + ⌥ Opt + I then B

Insert rows below

0
Ctrl + ⌥ Opt + E then D

(with rows selected) Delete rows

0
Ctrl + ⌥ Opt + -

(with columns selected)  Delete columns

0
Ctrl + ⌥ Opt + E then E

(with columns selected) Delete columns

0
Ctrl + ⌥ Opt + E then D

(with rows selected) Delete rows

0
Ctrl + ⌥ Opt + I then C

(with columns selected) Insert columns to the left

0
Ctrl + ⌥ Opt + I then O

Insert columns to the right

0
Ctrl + ⌥ Opt +   

Resize formula bar

Advertisement


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

Program information

Program name: Google Sheets (Mac) Google Sheets (Mac) (Productivity)

Web page: google.com/sheets

Last update: 17/1/2020 6:52 AM UTC

How easy to press shortcuts: 67%

More information >>

Shortcut count: 115

Platform detected: Windows and macOS mixed

Similar programs



User operations

Add Google Sheets (Mac) to your list of favorites

Advertisement


What is your favorite Google Sheets (Mac) 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