Keyboard shortcuts for Google Sheets

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 use an external keyboard with your iPhone or iPad, you can use the shortcuts below. This works with most kinds of external keyboards. 

Action Shortcut
Bold ⌘ + b
Underline ⌘ + u
Italicize ⌘ + i
Find and replace ⌘ + f
Strikethrough ⌘ + Shift + x
Undo ⌘ + z
Redo ⌘ + Shift + z
Select column Ctrl + Space
Select row Shift + Space
Select all ⌘ + a
Print ⌘ + p
Copy ⌘ + c
Cut ⌘ + x
Paste ⌘ + v
Center align ⌘ + Shift + e
Left align ⌘ + Shift + l
Right align ⌘ + Shift + r
Insert rows above ⌘ + Option + = (with rows selected)
Insert columns to the left ⌘ + Option + = (with columns selected)
Move selection by cell Up/Down/Left/Right arrow
Expand selection by cell Shift + Up/Down/Left/Right arrow
Move to the edge of the current data region ⌘ + Up/Down/Left/Right arrow
Expand the selection of cells to the edge of the current data region if the next cell is filled. Otherwise, expand the selected cell to the next empty cell in the specified direction. ⌘ + Shift + Up/Down/Left/Right arrow
Delete content from cell Backspace/Delete

 

 

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu