Google Sheets Keyboard Shortcuts for Windows
Google Sheets Keyboard Shortcuts for Windows. View hotkeys online or download free PDF Cheat Sheet to work faster and manage spreadsheets efficiently.
Common actions
- Select column
- Ctrl+Space
- Select row
- Shift+Space
- Select all
- Ctrl+AorCtrl+Shift+Space
- Undo
- Ctrl+Z
- Redo
- Ctrl+YorCtrl+Shift+ZorF4
- 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
- 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
- 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+7orCtrl+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+\
Navigate spreadsheet
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
Add or change rows and columns
- Insert rows above (with rows selected)
- Ctrl+Alt+=orAlt+I,R,RorAlt+Shift+I,R,R
- Insert rows below
- Alt+I,R,BorAlt+Shift+I,R,B
- Insert columns to the left (with columns selected)
- Ctrl+Alt+=orAlt+I,C,CorAlt+Shift+I,C,C
- Insert columns to the right
- Alt+I,C,OorAlt+Shift+I,C,O
- Delete rows (with rows selected)
- Ctrl+Alt+-orAlt+E,D,DorAlt+Shift+E,D,D
- Delete columns (with columns selected)
- Ctrl+Alt+-orAlt+E,D,EorAlt+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+UporCtrl+Down
- Toggle formula range selection (when entering a formula)
- F2orCtrl+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
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.