Google Sheets Keyboard Shortcuts for ChromeOS

Google Sheets Keyboard Shortcuts for ChromeOS. View hotkeys online or download free PDF Cheat Sheet to work faster with spreadsheets on Chromebooks.

Select column: Ctrl+Space
Select row: Shift+Space
Select all: Ctrl+A
Undo: Ctrl+Z
Redo: Ctrl+Shift+Z
or
Ctrl+Y
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
Tool finder (formerly Search the menus): Alt+/
Convert range to table: Alt+Shift+T

Bold: Ctrl+B
Underline: Ctrl+U
Italic: Ctrl+I
Strikethrough: Alt+Shift+5
Centre align: Ctrl+Shift+E
Left align: Ctrl+Shift+L
Right align: Ctrl+Shift+R
Apply top border: Alt+Shift+1
Apply right border: Alt+Shift+2
Apply bottom border: Alt+Shift+3
Apply left border: Alt+Shift+4
Remove borders: Alt+Shift+6

Apply outer border: Alt+Shift+7
or
Ctrl+Shift+7
Insert link: Ctrl+K
Insert time: Ctrl+Shift+;
Insert date: Ctrl+;
Insert date and time: Ctrl+Alt+Shift+;
Format as decimal: Ctrl+Shift+1
Format as time: Ctrl+Shift+2
Format as date: Ctrl+Shift+3
Format as currency: Ctrl+Shift+4
Format as percentage: Ctrl+Shift+5
Format as exponent: Ctrl+Shift+6
Clear formatting: Ctrl+\

Move to beginning of row: Super+Left
Move to end of row: Super+Right
Move to first cell in row with data: Ctrl+Left
Move to top left of sheet: Super+Ctrl+Left
Move to last cell in row with data: Ctrl+Right
Move to bottom right of sheet: Super+Ctrl+Right
Scroll to active cell: Ctrl+Bksp
Move to beginning of sheet: Super+Ctrl+Left
Move to end of sheet: Super+Ctrl+Right
Move to next sheet: Super+Ctrl+Shift+Down
Move to previous sheet: Super+Ctrl+Shift+Up

Display list of sheets: Alt+Shift+K
Open hyperlink: Alt+Enter
Open Explore: Ctrl+Alt+Shift+I
Go to side panel: Alt+Shift+.
or
Alt+Shift+,
Move focus out of spreadsheet: Ctrl+Alt+Shift+M
Move to quicksum (when a range of cells is selected): Alt+Shift+Q
Move focus to pop-up (for links, bookmarks and images): Ctrl+Alt+E,Ctrl+Alt+P
Open drop-down menu on filtered cell: Ctrl+Alt+R
Open revision history: Ctrl+Alt+Shift+H
Close drawing editor: Ctrl+Esc
or
Shift+Esc

Insert/edit note: Super+Shift+2
Insert/edit comment: Ctrl+Alt+M
Open comment discussion thread: Ctrl+Alt+Shift+A

Enter current comment: Ctrl+Alt+E,Ctrl+Alt+C
Move to next comment: Ctrl+Alt+N,Ctrl+Alt+C
Move to previous comment: Ctrl+Alt+P,Ctrl+Alt+C

Reply to current comment: R
Move to next comment: J
Move to previous comment: K

Resolve current comment: E
Exit current comment: U

File menu: Alt+F
Edit menu: Alt+E
View menu: Alt+V
Insert menu: Alt+I
Format menu: Alt+O
Data menu: Alt+D
Tools menu: Alt+T
Open insert menu (with cells selected): Ctrl+Alt+=

Open delete menu (with cells selected): Ctrl+Alt+-
Form menu (present when the spreadsheet is connected to a form): Alt+M
Add-ons menu: Alt+N
Help menu: Alt+H
Accessibility menu (present when screen reader support is enabled): Alt+A
Sheet menu (copy, delete and other sheet actions): Ctrl+Shift+S
Context menu: Ctrl+Shift+\
or
Shift+F10
Table column menu: Ctrl+Alt+\

Insert rows above (with rows selected): Ctrl+Alt+=
or
Alt+I,R,R
Insert rows below: Alt+I,R,B
Insert columns to the left (with columns selected): Ctrl+Alt+=
or
Alt+I,C,C
Insert columns to the right: Alt+I,C,O
Delete rows (with rows selected): Ctrl+Alt+-
or
Alt+E,D,D
Delete columns (with columns selected): Ctrl+Alt+-
or
Alt+E,D,E
Hide rows: Ctrl+Alt+9

Unhide rows: Ctrl+Shift+9
Hide columns: Ctrl+Alt+0
Unhide columns: Ctrl+Shift+0
Group rows or columns: Alt+Shift+Right
Ungroup rows or columns: Alt+Shift+Left
Expand grouped rows or columns: Alt+Shift+Down
Collapse grouped rows or columns: Alt+Shift+Up

Show all formulas: Ctrl+`
Insert array formula: Ctrl+Shift+Enter
Collapse an expanded array formula: Ctrl+E
Show/hide formula help (when entering a formula): Super+Shift+1
Full/compact formula help (when entering a formula): Super+1

Absolute/relative references (when entering a formula): Super+4
Toggle formula result previews (when entering a formula): Super+9
Resize formula bar (move up or down): Ctrl+Shift+Up
or
Ctrl+Shift+Down
Toggle formula range selection (when entering a formula): F2
or
Ctrl+E

Turn on screen reader support: Ctrl+Alt+Z
Enable braille support: Ctrl+Alt+H

Read column: Ctrl+Alt+Shift+C
Read row: Ctrl+Alt+Shift+R

Need more than shortcuts?
Visit the Google Sheets app page for an overview and helpful links.

Want to suggest a new app, report a bug, or get help? Email us at info@hkeys.app.

For anything else or just a quick hello, write to us at info@hkeys.app.