Google Sheets Keyboard Shortcuts for Android
Keyboard shortcuts for Google Sheets on Android. Navigate cells, build formulas, and manage spreadsheet data with a Bluetooth keyboard on Android.
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
- Ctrl+P
- Copy
- Ctrl+C
- Cut
- Ctrl+X
- Paste
- Ctrl+V
- Paste values only
- Ctrl+Shift+V
- Paste format only
- Ctrl+Alt+V
- Show common keyboard shortcuts
- Ctrl+/
- Insert new sheet
- Ctrl+TorShift+F11
- Move to sheet at index #
- Ctrl+[1-9]
- Open
- Ctrl+O
- Zoom in
- Ctrl+.
- Zoom out
- Ctrl+,
- Zoom 100%
- Alt+Shift+0
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 automatic
- Ctrl+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+\
- Insert rows (with rows selected)
- Ctrl+Alt+=orCtrl+Alt+Shift+=
- Insert columns (with columns selected)
- Ctrl+Alt+=orCtrl+Alt+Shift+=
- Delete rows (with rows selected)
- Ctrl+Alt+-
- Delete columns (with columns selected)
- Ctrl+Alt+-
- 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
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
Open a menu
Use formulas
- Insert array formula
- Ctrl+Shift+Enter
- Show expanded function help (when entering a formula)
- F1
- Toggle formula range selection (when entering a formula)
- F2orCtrl+E
- Absolute/relative range references (when entering a formula)
- F4
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.