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

How to Fix Microsoft Teams Error Z Zone

How to Fix Microsoft Teams Error Z Zone

Tired of Microsoft Teams "Error Z" Zone crashing your meetings? Follow our expert, step-by-step guide to fix it quickly with the latest methods. Regain seamless teamwork now!

How to Fix Microsoft Teams Check Version Error

How to Fix Microsoft Teams Check Version Error

Tired of the frustrating Microsoft Teams "Check Version" error blocking your meetings? Follow our proven, step-by-step fixes to resolve it fast and restore smooth teamwork. Works on latest versions!

How to Remove and Change a Microsoft Teams Account on Windows 11

How to Remove and Change a Microsoft Teams Account on Windows 11

Struggling with the wrong Microsoft Teams account on Windows 11? Discover simple, step-by-step instructions to remove and change your Microsoft Teams account effortlessly. Perfect for managing work and personal profiles!

How to Fix Microsoft Teams Guide Tutorial Error

How to Fix Microsoft Teams Guide Tutorial Error

Struggling with Microsoft Teams "Guide" Tutorial Error? Discover simple, step-by-step fixes to resolve it quickly. Clear cache, update, and more for seamless teamwork. Updated for latest versions!

Troubleshooting Microsoft Teams For Mac Sync Error

Troubleshooting Microsoft Teams For Mac Sync Error

Struggling with Microsoft Teams for Mac sync errors? Follow this ultimate troubleshooting guide with step-by-step fixes to resolve sync issues quickly and get back to seamless collaboration on macOS. Updated with the latest solutions.

Solving Microsoft Teams Website Error Loading

Solving Microsoft Teams Website Error Loading

Tired of the frustrating Microsoft Teams "Website Error" loading issue? Follow our proven, step-by-step fixes to resolve it fast and restore smooth teamwork. Works on all browsers!

Troubleshooting Microsoft Teams Remote Control Error

Troubleshooting Microsoft Teams Remote Control Error

Struggling with Microsoft Teams Remote Control Error? Discover step-by-step troubleshooting for Remote Control issues in Teams. Quick fixes, common causes, and expert tips to get back to seamless collaboration. Updated with the latest solutions.

Solving Microsoft Teams Media Error Microphone

Solving Microsoft Teams Media Error Microphone

Struggling with Microsoft Teams "Media Error" Microphone? Get instant fixes for crystal-clear audio. Step-by-step solutions for permissions, drivers, and more – no tech skills needed!

How to Fix Microsoft Teams Error on Desktop Shortcut

How to Fix Microsoft Teams Error on Desktop Shortcut

Tired of the frustrating Microsoft Teams "Error" on your desktop shortcut? Discover proven, step-by-step solutions to resolve it fast and restore smooth teamwork. No tech skills needed!

Troubleshooting Microsoft Teams Error P Password

Troubleshooting Microsoft Teams Error P Password

Stuck with Microsoft Teams "Error P" password error? Discover quick, effective troubleshooting steps to resolve login issues and get back to seamless collaboration in minutes. Updated with the latest fixes.

How to Fix Microsoft Teams Welcome Screen Stuck Error 2026

How to Fix Microsoft Teams Welcome Screen Stuck Error 2026

Frustrated with Microsoft Teams "Welcome" screen stuck on Error 2026? Discover proven, step-by-step fixes to resolve it fast and get back to seamless collaboration. Updated with the latest tips!

Troubleshooting Microsoft Teams Action Required Login Error

Troubleshooting Microsoft Teams Action Required Login Error

Struggling with Microsoft Teams "Action Required" login error? Discover step-by-step troubleshooting fixes, clear cache methods, and quick solutions to get back to seamless collaboration. Updated with the latest tips for instant relief.

How to Fix Microsoft Teams Webinar Registration Error

How to Fix Microsoft Teams Webinar Registration Error

Facing Microsoft Teams Webinar Registration Error? Follow our proven, step-by-step guide to fix it quickly and get back to seamless webinar registrations. Latest troubleshooting tips included!

How to Fix Microsoft Teams Joining Error Meeting Full

How to Fix Microsoft Teams Joining Error Meeting Full

Tired of Microsoft Teams "Joining Error: Meeting Full"? Get proven, step-by-step solutions to bypass the error and join instantly. Latest fixes for seamless meetings!

Solving Microsoft Teams Recording Error: Permission Required

Solving Microsoft Teams Recording Error: Permission Required

Tired of the frustrating Microsoft Teams recording error: Permission Required? Follow our expert, step-by-step guide to regain recording access instantly with the latest Teams policies and fixes. No tech skills needed!