Google Sheets Keyboard Shortcuts for Android
Google Sheets Keyboard Shortcuts for Android. View online or download free PDF Cheat Sheet to work faster with spreadsheets on tablets and phones.
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.