- You can use Google Sheets keyboard shortcuts to save time and make the most of the spreadsheet program.
- The keyboard shortcuts perform the same functions regardless of platform, but require you to press different keys depending on whether you're using Windows or MacOS.
- Visit Business Insider's Tech Reference library for more stories.
Like Microsoft Excel, Google Sheets offers users the ability to exploit keyboard shortcuts for a speedier experience. Here are the 35 best keyboard shortcuts for Google Sheets, for both Windows and Mac.
Note: a dash "-" in the following shortcuts indicates that the keys should be pressed at the same time. If the keyboard shortcut in question requires a dash, it will be listed as "Minus."
Check out the products mentioned in this article:
Windows 10 (From $139.99 at Best Buy)
Apple Macbook Pro (From $1,299.00 at Apple)
The 35 best Google Sheets keyboard shortcuts on Windows
- Select a column: Ctrl-Spacebar
- Select a row: Shift-Space bar
- Select all fields: Ctrl-A or Ctrl-Shift-Spacebar
- Undo an action: Ctrl-Z
- Redo an action: Ctrl-Y or Ctrl-Shift-Z or F4
- Find a phrase in the workbook: Ctrl-F
- Find and replace a phrase in the workbook: Ctrl-H
- Print: Ctrl-P
- Copy: Ctrl-C
- Cut: Ctrl-X
- Paste: Ctrl-V
- Paste values without formatting: Ctrl-Shift-V
- Show common keyboard shortcuts: Ctrl-/
- Bold text: Ctrl-B
- Underline text: Ctrl-U
- Italicize text: Ctrl-i
- Strikethrough text: Alt-Shift-5
- Center values: Ctrl-Shift-e
- Align values to the left: Ctrl-Shift-l
- Align values to the right: Ctrl-Shift-R
- Insert a link: Ctrl-K
- Clear formatting: Ctrl-\
- Navigate to the beginning of a row: Home
- Navigate to the beginning of a sheet: Ctrl-Home
- Move to the end of a row: End
- Move to the end of a sheet: Ctrl-End
- Scroll to the active cell: Ctrl-Backspace
- Open a hyperlink: Alt-Enter
- Insert rows above the current row: Ctrl-Alt-Shift-Equals sign or Ctrl-Alt-Equals sign (for the latter, you'll need to select at least one row)
- Insert rows below the current row: Alt-i-W (if using Google Chrome) or Alt-Shift-i-W (if using a different browser)
- Insert columns to the left of the current column: Ctrl-Alt-Shift-Equals sign or Ctrl-Alt-Equals sign (for the latter, you'll need to select at least one column)
- Insert columns to the right of the current column: Alt-i-O (if using Google Chrome) or Alt-Shift-i-O (if using a different browser)
- Delete rows: Ctrl-Alt-Minus (you'll need to select the rows you want to delete before you use this shortcut)
- Delete columns: Ctrl-Alt-Minus (you'll need to select the columns you want to delete before you use this shortcut)
- Show or hide the formula help menu: Shift-F1 (only accessible when entering a formula)
The 35 best Google Sheets keyboard shortcuts on Mac
- Select a column: Ctrl-Spacebar
- Select a row: Shift-Spacebar
- Select all fields: Command-A or Command-Shift-Space bar
- Undo an action: Command-Z
- Redo an action: Command-Y or Command-Shift-Z or Fn-F4
- Find a phrase in the workbook: Command-F
- Find and replace a phrase in the workbook: Command-Shift-H
- Print: Command-P
- Copy: Command-C
- Cut: Command-X
- Paste: Command-V
- Paste values without formatting: Command-Shift-V
- Show common keyboard shortcuts: Command-/
- Bold text: Command-B
- Underline text: Command-U
- Italicize text: Command-i
- Strikethrough text: Control-Shift-5
- Center values: Command-Shift-E
- Align values to the left: Command-Shift-i
- Align values to the right: Command-Shift-R
- Insert a link: Command-K
- Clear formatting: Command-\
- Navigate to the beginning of a row: Fn-Left arrow
- Navigate to the beginning of a sheet: Command-Fn-Left
- Move to the end of a row: Fn-Right
- Move to the end of a sheet: Command-Fn-Right
- Scroll to the active cell: Command-Backspace
- Open a hyperlink: Option-Enter
- Insert rows above the current row: Command-Option-Equals sign or Ctrl-Option-i-C (for the former, you'll need to select at least one row)
- Insert rows below the current row: Ctrl-Option-i-B
- Insert columns to the left of the current column: Ctrl-Options-Equals sign or Ctrl-Alt-Equals sign (for the latter, you'll need to select at least one column)
- Insert columns to the right of the current column: Ctrl-Option-i-O
- Delete rows: Command-Option-Minus or Ctrl-Option-E-D (for the former, you'll need to select the rows you want to delete before you use this shortcut)
- Delete columns: Command-Option-Minus sign or Ctrl-Option-E and then press E again (you'll need to select the columns you want to delete before you use this shortcut)
- Show or hide the formula help menu: Shift-Fn-F1 (only accessible when entering a formula)
$139.99 from Best Buy
$1,299.00 from Apple
$1,199.99 from Best Buy
Related coverage fromTech Reference:
How to add cells in Google Sheets on your PC or Mac
How to unhide columns and rows in Google Sheets on desktop and mobile
How to multiply in Google Sheets in 3 ways, using a multiplication formula
How to freeze columns in Google Sheets on desktop or mobile
How to add a drop-down list in Google Sheets to group and organize data in your spreadsheet
Chrissy Montelli
Chrissy Montelli is a writer and content creator originally from Long Island, NY. She is the author of two poetry chapbooks,Heart Float(Bottlecap Press) andGoing to Ithaca(Ghost City Press), as well as various online publications.
Read more from her atchrissymontelli.wordpress.com.
Read more
Read less