Google Sheets formula shortcuts

• 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)

Microsoft Windows 10 Home

$139.99 from Best Buy

Apple Macbook Pro 13-Inch Display with Touch Bar

$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