Google Sheets Keyboard Shortcuts for Windows

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

Common actions

Select column
Ctrl+Space
Select row
Shift+Space
Select all
Ctrl+A
or
Ctrl+Shift+Space
Undo
Ctrl+Z
Redo
Ctrl+Y
or
Ctrl+Shift+Z
or
F4
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+/
Insert new sheet
Shift+F11
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+/
Rename sheet
Alt+1
Convert range to table
Ctrl+Alt+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
Shift+F2
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
or
Alt+Shift+F
Edit menu
Alt+E
or
Alt+Shift+E
View menu
Alt+V
or
Alt+Shift+V
Insert menu
Alt+I
or
Alt+Shift+I
Format menu
Alt+O
or
Alt+Shift+O
Data menu
Alt+D
or
Alt+Shift+D
Tools menu
Alt+T
or
Alt+Shift+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
or
Alt+Shift+M
Add-ons menu
Alt+N
or
Alt+Shift+N
Help menu
Alt+H
or
Alt+Shift+H
Accessibility menu (present when screen reader support is enabled)
Alt+A
or
Alt+Shift+A
Sheet menu (copy, delete and other sheet actions)
Alt+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
or
Alt+Shift+I,R,R
Insert rows below
Alt+I,R,B
or
Alt+Shift+I,R,B
Insert columns to the left (with columns selected)
Ctrl+Alt+=
or
Alt+I,C,C
or
Alt+Shift+I,C,C
Insert columns to the right
Alt+I,C,O
or
Alt+Shift+I,C,O
Delete rows (with rows selected)
Ctrl+Alt+-
or
Alt+E,D,D
or
Alt+Shift+E,D,D
Delete columns (with columns selected)
Ctrl+Alt+-
or
Alt+E,D,E
or
Alt+Shift+E,D,E
Hide row
Ctrl+Alt+9
Unhide row
Ctrl+Shift+9
Hide column
Ctrl+Alt+0
Unhide column
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)
Shift+F1
Full/compact formula help (when entering a formula)
F1
Absolute/relative references (when entering a formula)
F4
Toggle formula result previews (when entering a formula)
F9
Resize formula bar (move up or down)
Ctrl+Up
or
Ctrl+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 Windows runs in the browser, Chrome, Edge, Firefox, or another supported browser. There is no separate native Windows app. The shortcut set uses Ctrl as its primary modifier. Ctrl+/ opens the built-in shortcut reference panel within Sheets without leaving the spreadsheet.

Windows-specific shortcut notes

Built-in shortcut list. Ctrl+/ opens Google Sheets' keyboard shortcut panel. Searchable and categorized, the fastest way to find a Sheets shortcut you've forgotten without switching to another tab.

Data range navigation. Ctrl+Arrow jumps to the last filled cell in the arrow's direction. Ctrl+Down from a cell in the middle of a data column jumps to the last row of data in one keystroke. Ctrl+Shift+Arrow extends the selection to the data range boundary. These are the shortcuts that make navigating large datasets practical without a mouse, and they match Excel on Windows exactly.

Paste values only. Ctrl+Shift+V pastes the clipboard contents as values only, stripping source formatting and formulas. This is a frequently used operation in spreadsheet work that avoids the more complex Paste Special dialog.

Formula entry. Entering and exiting cell edit mode, navigating within the formula bar, and managing formula autocomplete suggestions all have keyboard controls. These are in the table above.

Menu bar access. Pressing Alt in Google Sheets on Windows activates menu navigation (File, Edit, View, Insert, Format, Data, Tools, Extensions, Help). This gives keyboard access to any Sheets feature, including those without a direct shortcut.

Strikethrough. Alt+Shift+5 applies strikethrough formatting in Google Sheets on Windows, the same shortcut as in Google Docs on Windows. Consistent across Google Workspace apps.

Printable PDF

The Google Sheets Windows shortcut list is available as a printable PDF. Cell navigation and formula entry shortcuts are the most valuable to print for anyone spending significant time in Sheets.

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.