Google Sheets (Mac) keyboard shortcuts 

Google Sheets (Mac)    

Zeynel -
7 years ago
- Shortcuts

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

0
↑  Shift + F2

Insert/edit note

0
Alt + H

(in Google Chrome) Help menu

0
Ctrl + ~

Show all formulas

0
⌘ Cmd + E

Collapse an expanded array formula

2
Fn + F1

(when entering a formula) Full / compact formula help

5
Fn + F4

(when entering a formula) Absolute/relative references

0
⌘ Cmd + A

Select all

3
Fn + F4

Redo

0
⌘ Cmd + F

Find

0
⌘ Cmd + D

Fill down

0
⌘ Cmd + R

Fill right

0
⌘ Cmd + S

Save (every change is saved automatically in Drive)

0
⌘ Cmd + C

Copy

0
⌘ Cmd + X

Cut

0
⌘ Cmd + V

Paste

0
⌘ Cmd + Z

Undo

0
⌘ Cmd + Y

Redo

0
⌘ Cmd + B

Bold

-2
⌘ Cmd + ↑  Shift + Z

Redo

0
Ctrl + ↑  Shift + F

Compact controls

0
⌘ Cmd + ↑  Shift + E

Center align

0
⌘ Cmd + ↑  Shift + R

Right align

0
⌘ Cmd + ↑  Shift + V

Paste values only

0
⌘ Cmd + ↑  Shift + H

Find and replace

-1
Ctrl + Space

Select column

-1
↑  Shift + Space

Select row

0
↑  Shift + Esc

Open chat inside the spreadsheet

0
Ctrl + ↑  Shift + 1

Format as decimal

0
Ctrl + ↑  Shift + 2

Format as time

-1
Ctrl + ↑  Shift + 3

Format as date

0
Ctrl + ↑  Shift + 4

Format as currency

0
Ctrl + ↑  Shift + 5

Format as percentage

0
⌥ Opt + ↑  Shift + S

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

0
Alt + ↑  Shift + H

(in other browsers) Help menu

0
↑  Shift + Esc

Close drawing editor

0
⌘ Cmd + K

Insert link

0
⌘ Cmd + ;

Insert date

0
⌘ Cmd + ⌥ Opt + M

Insert/edit comment

0
⌥ Opt + ⤶ Enter

Open hyperlink

0
⌘ Cmd + ⤶ Enter

Fill range

0
⌘ Cmd + O

Open

0
⌘ Cmd + P

Print

0
⌘ Cmd + U

Underline

0
⌘ Cmd + ↑  Shift + K

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

0
⌥ Opt + ↑  Shift + 1

Apply top border

0
⌥ Opt + ↑  Shift + 2

Apply right border

0
⌥ Opt + ↑  Shift + 3

Apply bottom border

1
⌥ Opt + ↑  Shift + 4

Apply left border

0
⌘ Cmd + ↑  Shift + L

Left align

0
⌥ Opt + ↑  Shift + 5

Strikethrough

0
⌥ Opt + ↑  Shift + X

Open Explore

0
⌥ Opt + ↑  Shift + Q

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

0
⌘ Cmd + ↑  Shift + 7

Apply outer border

0
Ctrl + ⌘ Cmd + R

Open drop-down menu on filtered cell

0
Ctrl + ↑  Shift + 6

Format as exponent

0
Ctrl + ⌥ Opt + M

Form menu

0
Ctrl + ⌥ Opt + N

Add-ons menu

0
Ctrl + ⌥ Opt + A

Accessibility menu

0
Ctrl + ⌥ Opt + A

(present when screen reader support is enabled) Accessibility menu

Advertisement

0
Ctrl + ⌥ Opt + F

File menu

0
Ctrl + ⌥ Opt + E

Edit menu

0
Ctrl + ⌥ Opt + V

View menu

0
Ctrl + ⌥ Opt + D

Data menu

0
Ctrl + ⌥ Opt + T

Tools menu

0
⌘ Cmd + ↑  Shift + ⤶ Enter

Insert array formula

0
↑  Shift + Fn + F1

(when entering a formula) Show/hide formula help

-1
⌘ Cmd + ⌥ Opt + Z

Turn on screen reader support

0
⌘ Cmd + ⌥ Opt + 0

Hide column

0
⌘ Cmd + Esc

Close drawing editor

0
⌘ Cmd + İ

Italic

-2
⌘ Cmd + /

Show common keyboard shortcuts

0
⌘ Cmd + ↑  Shift + Space

Select all

0
⌥ Opt + ↑  Shift + 6

Remove borders

1
⌥ Opt + ↑  Shift + 7

Apply outer border

0
⌥ Opt + ↑  Shift + K

Display list of sheets

0
⌘ Cmd + ↑  Shift + ;

Insert time

0
Ctrl + ⌥ Opt + I

Insert menu

0
Ctrl + ⌥ Opt + O

Format menu

0
Ctrl + ⌥ Opt +   

Resize formula bar

0
⌘ Cmd + ⌥ Opt + 9

Hide row

0
Fn + F9

(when entering a formula) Toggle formula result previews

0
⌘ Cmd + ⌥ Opt + =

(with cells selected) Open insert menu

0
⌘ Cmd + ⌥ Opt + =

(with rows selected) Insert rows above

0
⌘ Cmd + ⌥ Opt + =

(with columns selected) Insert columns to the left

0
Fn +

Move to beginning of row

0
Fn +

Move to end of row

0
Ctrl + ⌥ Opt + -

(with columns selected)  Delete columns

1
⌘ Cmd + ⌥ Opt + -

(with rows selected) Delete rows

0
or ⌘ Cmd + ⌥ Opt + -
0
⌘ Cmd + ⌥ Opt + -

(with cells selected)  Open delete menu

0
⌘ Cmd + ⌥ Opt + ↑  Shift + C

Read column

0
⌘ Cmd + ⌥ Opt + ↑  Shift + R

Read row

0
⌘ Cmd + \

Clear formatting

0
⌘ Cmd + Backspace

Scroll to active cell

0
Ctrl + ⌘ Cmd + ↑  Shift + M

Move focus out of spreadsheet

0
⌘ Cmd + ⌥ Opt + ↑  Shift + H

Open revision history

0
⌘ Cmd + ⌥ Opt + ↑  Shift + A

Open comment discussion thread

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

0
Ctrl + ⌘ Cmd then E then P

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

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

Insert date and time

0
⌘ Cmd + ⌥ Opt + ↑  Shift + K

Select input tools

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

1
Ctrl + ⌥ Opt + I then R

(with rows selected) Insert rows above

0
Ctrl + ⌥ Opt + I then B

Insert rows below

0
⌘ Cmd + ↑  Shift + \

Context menu

0
Ctrl + ⌥ Opt + E then D

(with rows selected) Delete rows

0
Ctrl + ⌥ Opt + E then E

(with columns selected) Delete columns

0
⌘ Cmd + Fn +

Move to end of sheet

0
⌘ Cmd + Fn +

Move to beginning of sheet

0
⌘ Cmd + ↑  Shift + Fn +

Move to next sheet

0
Ctrl + ↑  Shift + Fn +

Move to previous sheet

Advertisement


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



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!