Use keyboard shortcuts in Google Sheets to navigate, format, and use formulas.
Note: Some shortcuts might not work for all languages or keyboards.
If you plug an external keyboard into your Android device, you can use the shortcuts below. This works with most kinds of external keyboards.
Common actions
Action | Shortcut |
---|---|
Select column | Ctrl + Space |
Select row | Shift + Space |
Select all | Ctrl + a Ctrl + Shift + Space |
Undo | Ctrl + z |
Redo | Ctrl + y Ctrl + Shift + z F4 |
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 + t Shift + F11 |
Move to sheet at index # | Ctrl + [1-9] |
Open | Ctrl + O |
Format cells
Action | Shortcut |
---|---|
Bold | Ctrl + b |
Underline | Ctrl + u |
Italic | Ctrl + i |
Strikethrough | Alt + Shift + 5 |
Center 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 Ctrl + 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 |
Ctrl + Alt + = |
Insert columns |
Ctrl + Alt + = |
Delete rows | Ctrl + Alt + - (with rows selected) |
Delete columns | Ctrl + Alt + - (with columns selected) |
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 arrow |
Ungroup rows or columns | Alt + Shift + Left arrow |
Expand grouped rows or columns | Alt + Shift + Down arrow |
Collapse grouped rows or columns | Alt + Shift + Up arrow |
Navigate spreadsheet
Action | Shortcut |
---|---|
Move to section boundary | Ctrl + Arrow keys |
Select from current position to section boundary | Ctrl + Shift + Arrow keys |
Scroll to active cell | Ctrl + Backspace |
Move to next sheet | Alt + Down arrow Ctrl + Shift + Page Down |
Move to previous sheet | Alt + Up arrow Ctrl + Shift + Page Up |
Display list of sheets | Alt + Shift + k |
Open hyperlink | Alt + Enter |
Open Explore | Alt + Shift + x |
Open menu on filtered cell | Ctrl + Alt + Shift + r Ctrl + Alt + r |
Move to beginning of row | Home |
Move to beginning of sheet | Ctrl + Home |
Move to end of row | End |
Move to end of sheet | Ctrl + End |
Edit notes and comments
Action | Shortcut |
---|---|
Insert/edit note | Shift + F2 |
Insert/edit comment | Ctrl + Alt + m |
Open comment discussion thread | Ctrl + Alt + Shift + a |
Open a menu
Action | Shortcut |
---|---|
Insert menu | Alt + i |
Format menu | Alt + o |
Sheet menu (copy, delete, and other sheet actions) |
Alt + Shift + s |
Context menu |
Ctrl + Shift + \ Right-click |
Use formulas
Action | Shortcut |
---|---|
Insert array formula |
Ctrl + Shift + Enter |
Show expanded function help (when entering a formula) |
F1 |
Toggle formula range selection (when entering a formula) |
F2 |
Absolute/relative range references (when entering a formula) |
F4 |