Google Sheets Keyboard Shortcuts for ChromeOS

Keyboard shortcuts for Google Sheets on ChromeOS. Navigate cells, build formulas, and manage spreadsheet data on a Chromebook.
Key label style

Common actions

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

Format cells

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 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+\

Edit notes and comments

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

Use keyboard shortcuts on selected comments

Reply to current comment
R
Move to next comment
J
Move to previous comment
K
Resolve current comment
E
Exit current comment
U

Open a menu

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+\

Add or change rows and columns

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

Use formulas

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

Help for screen readers

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

Intro

Google Sheets on ChromeOS is, for most Chromebook users, the primary spreadsheet application. Microsoft Excel does not have a native ChromeOS app, the nearest equivalent is Excel for the web, which also runs in the browser. For Chromebook users doing serious spreadsheet work, Google Sheets is where it happens.

The ChromeOS shortcut set for Sheets uses Ctrl as its primary modifier, identical to Windows. If you've used Sheets on Windows, every shortcut transfers directly to ChromeOS.

ChromeOS-specific shortcut notes

Ctrl as primary modifier. The full Google Sheets shortcut set on ChromeOS uses Ctrl throughout, matching Windows. Data range navigation (Ctrl+Arrow), selection extensions (Ctrl+Shift+Arrow), paste values only (Ctrl+Shift+V), and all other Ctrl-based shortcuts apply here as on Windows.

Built-in shortcut list. Ctrl+/ opens Google Sheets' shortcut reference panel on ChromeOS, the same as on Windows. This is the fastest in-app shortcut lookup available.

The Search/Launcher key. Chromebooks replace the standard Caps Lock key with the Search/Launcher key. This key appears in ChromeOS system shortcuts but rarely in Google Sheets-specific shortcuts. Knowing it's in the Caps Lock position helps if you're looking for that key.

Chromebook keyboard and the top row. Chromebook keyboards use the top row for system controls (brightness, volume, refresh, fullscreen) rather than F-keys. Google Sheets on ChromeOS uses Ctrl-based shortcuts rather than F-key shortcuts, so this doesn't create gaps in spreadsheet shortcut coverage. The table above notes any cases where this matters.

Data range navigation. Ctrl+Arrow jumps to the last filled cell in any direction, one of the most valuable shortcuts for working with real data on any platform. This works the same on ChromeOS as on Windows.

Menu access. Alt activates menu navigation in Google Sheets on ChromeOS, giving keyboard access to all Sheets features, the same as on Windows.

Printable PDF

The Google Sheets ChromeOS shortcut list is available as a printable PDF. The cell navigation and formula entry sections are the most useful for Chromebook-primary spreadsheet work.

FAQ

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.