Common keyboard shortcuts for Google Sheets

Google Sheets is an online spreadsheet creator that allows users to create and edit spreadsheet files quickly and conveniently. Similar to Google Docs , Google Sheets also has a lot of keyboard shortcuts to help users enter data faster.

So invite you to follow the article below to grasp the list of common shortcuts on Google Sheets spreadsheet application:

Common keyboard shortcuts for Google Sheets

Common keyboard shortcuts for Google Sheets on your computer

General action shortcuts:

  • Ctrl + Space: Select column.
  • Shift + Space: Select row.
  • Ctrl + A or Ctrl + Shift + Space: Select all.
  • Ctrl + Shift + Backspace: Hide the selected cell Background.
  • Ctrl + Z ( Undo) : Return.
  • Ctrl + Y or Ctrl + Shift + Z or F4 ( Redo) : Repeat.
  • Ctrl + F: Search.
  • Ctrl + H: Search and replace.
  • Ctrl + Enter: Fill range.
  • Ctrl + D: Fill down.
  • Ctrl + R: Fill right
  • Ctrl + S: Save.
  • Ctrl + O: Open the saved file.
  • Ctrl + P: Print.
  • Ctrl + C: Copy.
  • Ctrl + X: Cut.
  • Ctrl + V: Paste.
  • Ctrl + Shift + V: Paste the value.
  • Ctrl + /: Display keyboard shortcuts.
  • Shift + F11: Insert a new Sheet.
  • Ctrl + Shift + F: Adjust Compact.
  • Ctrl + Shift + K: Turns the Input Tool on / off.
  • Ctrl + Alt + Shift + K: Select the Input Tool.

Cell format keyboard shortcuts:

  • Ctrl + B: Bold.
  • Ctrl + U: Underline.
  • Ctrl + I: Italicize.
  • Alt + Shift + 5: Strikethrough.
  • Ctrl + Shift + E: Center .
  • Ctrl + Shift + L: Align left.
  • Ctrl + Shift + R: Right-align.
  • Alt + Shift + 1: Format cell border, table border above.
  • Alt + Shift + 2: Format cell border, right table border.
  • Alt + Shift + 3: Format cell border, bottom table border.
  • Alt + Shift + 4: Format cell border, left table border.
  • Alt + Shift + 6: Delete border formatting.
  • Alt + Shift + 7: Format cell border, outer table border.
  • Ctrl + K: Insert a Hyperlink.
  • Ctrl + Shift + ;: Insert time.
  • Ctrl + ;: Insert date.
  • Ctrl + Shift + 1: Format a decimal number.
  • Ctrl + Shift + 2: Format time.
  • Ctrl + Shift + 3: Format the date.
  • Ctrl + Shift + 4: Curency number format with two decimal places.
  • Ctrl + Shift + 5: Percentage number format without decimal places.
  • Ctrl + Shift + 6: Exponential type number format with two decimal places.
  • Ctrl + \: Delete formatting.

Spreadsheet navigation keyboard shortcuts:

  • Home: Move to the top of the row.
  • Ctrl + Home: Move to the top of the table.
  • End: Move to the end of the row.
  • Ctrl + End: Move to the end of the table
  • Ctrl + Backspace: Move to the working cell.
  • Ctrl + Shift + Page Down: Move to the next panel.
  • Ctrl + Shift + Page Up: Move to the previous panel.
  • Alt + Shift + K: Display the table list.
  • Alt + Enter: Open the Hyperlink link.
  • Ctrl + Alt + Shift + M: Move Focus out of the spreadsheet.
  • Alt + Shift + Q: Move to Quicksum.
  • Hold down Ctrl + Alt, press E, then press P: Move Focus to the Popup Menu.
  • Ctrl + Alt + R: Open the menu to filter cell data.
  • Ctrl + Alt + Shift + G: Open history.
  • Shift + Esc: Open the chat inside the Spreadsheet.
  • Shift + Esc: Close the drawing editor.

Comment and comment editing shortcuts:

  • Shift + F2: Insert / edit caption.
  • Ctrl + Alt + M: Insert / edit comment.
  • Ctrl + Alt + Shift + A: Open the discussion topic.
  • Hold down Ctrl + Alt, press E, and then press C: Enter current comment.
  • Hold down Ctrl + Alt, press N, and then press C: Move to the next comment.
  • Hold down Ctrl + Alt, press P, then press C: Move back to previous comment.

Shortcut to open Menu:

Open the File Menu:

  • Alt + F: On the Google Chrome browser .
  • Alt + Shift + F: In another browser.

Open the Edit Menu:

  • Alt + E: On the Google Chrome browser.
  • Alt + Shift + E: In another browser.

Open Menu View:

  • Alt + V: On the Google Chrome browser.
  • Alt + Shift + V: In another browser.

Open the Insert Menu:

  • Alt + I: On the Google Chrome browser.
  • Alt + Shift + I: In another browser.

Open the Format Menu:

  • Alt + O: On Google Chrome browser.
  • Alt + Shift + O: In another browser.

Open the Data Menu:

  • Alt + D: On the Google Chrome browser.
  • Alt + Shift + D: In another browser.

Open Menu Tool:

  • Alt + T: On the Google Chrome browser.
  • Alt + Shift + T: In another browser.

Open Menu Form:

  • Alt + M: On the Google Chrome browser.
  • Alt + Shift + M: In another browser.

Open Menu Add-ons:

  • Alt + N: On the Google Chrome browser.
  • Alt + Shift + N: In another browser.

Open the Help Menu:

  • Alt + H: On the Google Chrome browser.
  • Alt + Shift + H: In another browser.

Open the Accessibility Menu:

  • Alt + A: On the Google Chrome browser.
  • Alt + Shift + A: In another browser.

Alt + Shift + S: Open the Sheet Menu.

Ctrl + Shift + \: Open the Context Menu.

Keyboard shortcut for inserting or deleting rows / columns:

Insert the above row:

  • Hold Alt + I, then press R: On the Google Chrome browser.
  • Hold down Alt + Shift + I, then press R: In another browser.

Insert row below:

  • Hold Alt + I, then press W: On the Google Chrome browser.
  • Hold down Alt + Shift + I, and then press W: In another browser.

Insert left column:

  • Hold Alt + I, and then press C: On the Google Chrome browser.
  • Hold down Alt + Shift + I, and then press C: In another browser.

Insert right column:

  • Hold Alt + I, then press G: On the Google Chrome browser.
  • Hold down Alt + Shift + I, then press G: In another browser.

Delete rows:

  • Hold Alt + E, then press D: On the Google Chrome browser.
  • Hold down Alt + Shift + E, then press D: In another browser.

Delete columns:

  • Hold Alt + E, then press E: On the Google Chrome browser.
  • Hold down Alt + Shift + E, then press E: In another browser.

Keyboard shortcuts to open formulas:

  • Ctrl + ~: Display all formulas.
  • Ctrl + Shift + Enter: Insert an array formula (Array formula).
  • Ctrl + E: Collapse the array formula extension.
  • Shift + F1: Show / hide the formula assistant menu.

Keyboard shortcuts for screen reading support:

  • Ctrl + Alt + Z: Activate the screen reading mode.
  • Ctrl + Alt + Shift + C: Read the text in the column.
  • Ctrl + Alt + Shift + R: Read the text in the row.

Leave a Comment

Troubleshooting Microsoft Teams Download Error on Macbook

Troubleshooting Microsoft Teams Download Error on Macbook

Facing Microsoft Teams "Download Error" on MacBook? Discover proven troubleshooting steps to resolve download failures quickly, from cache clears to reinstalls, and get back to smooth teamwork.

Troubleshooting Microsoft Teams Where is Teams Folder Error

Troubleshooting Microsoft Teams Where is Teams Folder Error

Tired of the frustrating Microsoft Teams "Where is Teams" Folder Error? Discover proven, step-by-step troubleshooting fixes to resolve it quickly and restore smooth teamwork. Latest methods included!

How to Fix Microsoft Teams JavaScript Error on Desktop App

How to Fix Microsoft Teams JavaScript Error on Desktop App

Frustrated by Microsoft Teams JavaScript Error on desktop app? Discover proven steps to fix it fast: clear cache, update, reset, and reinstall. Get back to seamless collaboration in minutes!

How to Fix Microsoft Teams Guest Login Error

How to Fix Microsoft Teams Guest Login Error

Struggling with Microsoft Teams "Guest Login" Error? Discover step-by-step fixes, from quick cache clears to admin settings, to resolve guest access issues fast and collaborate seamlessly. Updated with the latest tips!

How to Fix Microsoft Teams For PC Download Error

How to Fix Microsoft Teams For PC Download Error

Tired of the Microsoft Teams "For PC" download error blocking your work? Follow our proven, step-by-step guide to resolve it quickly and get Teams running smoothly on your PC today.

Solving Microsoft Teams Windows 7 Login Error

Solving Microsoft Teams Windows 7 Login Error

Struggling with Microsoft Teams "Windows 7" login error? Discover step-by-step fixes for this frustrating issue on Windows 10/11. Clear cache, edit registry, and more – get back to seamless collaboration today!

How to Fix Microsoft Teams Error Code 0x80070005 (2026 Guide)

How to Fix Microsoft Teams Error Code 0x80070005 (2026 Guide)

Tired of Microsoft Teams Error Code 0x80070005 blocking your meetings? Follow this 2026 guide with step-by-step fixes for access denied issues. Get Teams running smoothly in minutes!

How to Install the Microsoft Teams Add-in for Outlook 2026

How to Install the Microsoft Teams Add-in for Outlook 2026

Master the installation of the Microsoft Teams Add-in for Outlook 2026 effortlessly. Boost your productivity with seamless scheduling and meetings. Follow our proven, up-to-date steps for instant success!

How to Fix Microsoft Teams License Error 2026

How to Fix Microsoft Teams License Error 2026

Struggling with Microsoft Teams "License Error" 2026? Discover proven, step-by-step solutions to resolve it fast. Clear cache, check licenses, and get back to seamless collaboration—no IT help needed!

The Best Exercises for 50+

The Best Exercises for 50+

Whether youre in your 50s, 60s, or even 70s, its not too late to prioritize your health and put yourself first. Here are the best exercises for people 50 and older.

Solving Microsoft Teams Error Caa50024 on Windows 10/11

Solving Microsoft Teams Error Caa50024 on Windows 10/11

Struggling with Microsoft Teams Error Caa50024 on Windows 10/11? Follow our step-by-step fixes to resolve crashes and launch issues quickly. Latest proven solutions for seamless teamwork.

How to Fix Microsoft Teams Login Error AADSTS50011

How to Fix Microsoft Teams Login Error AADSTS50011

Stuck with Microsoft Teams login error AADSTS50011? Discover proven, step-by-step fixes to resolve the reply URL mismatch issue and log in seamlessly. No tech skills needed!

How to Fix Microsoft Teams Win 7 Compatibility Error

How to Fix Microsoft Teams Win 7 Compatibility Error

Tired of the frustrating Microsoft Teams "Win 7" Compatibility Error blocking your meetings? Get instant fixes with our step-by-step guide, including workarounds for older Windows versions. Resolve it now and stay connected!

Solving Microsoft Teams Error R Restart

Solving Microsoft Teams Error R Restart

Tired of the endless Microsoft Teams "Error R" restart loop? Get step-by-step fixes to solve Microsoft Teams Error R quickly. Clear cache, reset, reinstall & more for smooth collaboration. Works on Windows, Mac & web.

Solving Microsoft Teams Bị lỗi Troubleshooting Guide

Solving Microsoft Teams Bị lỗi Troubleshooting Guide

Struggling with Microsoft Teams "Bị lỗi" issues? Discover proven fixes for crashes, sign-in errors, and more in this comprehensive troubleshooting guide. Get back to seamless collaboration!