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

Solving Microsoft Teams Network Error on Public Wi-Fi

Solving Microsoft Teams Network Error on Public Wi-Fi

Struggling with Microsoft Teams "Network Error" on public Wi-Fi? Get instant fixes like VPN tweaks, port checks, and cache clears to restore calls and meetings seamlessly. Step-by-step guide for quick relief.

How to Fix Microsoft Teams Wheres My Team Search Error

How to Fix Microsoft Teams Wheres My Team Search Error

Tired of the frustrating Microsoft Teams "Where\

Microsoft Teams for Students: How to Join Classes in 2026

Microsoft Teams for Students: How to Join Classes in 2026

Unlock seamless learning with Microsoft Teams for Students! Step-by-step guide to joining classes in 2026, troubleshooting tips, and pro hacks for ultimate success. Perfect for students everywhere.

Solving Microsoft Teams License Error 0x80048504

Solving Microsoft Teams License Error 0x80048504

Tired of Microsoft Teams License Error 0x80048504 blocking your meetings? Get instant fixes with proven steps to resolve it permanently. Clear cache, reset licenses, and more – works every time!

How to Fix Microsoft Teams Remove Account Error

How to Fix Microsoft Teams Remove Account Error

Struggling with Microsoft Teams "Remove Account" error? Discover step-by-step fixes to resolve it quickly. Clear cache, reset app, and more for seamless account management in the latest Teams version.

How to Fix Microsoft Edge Not Working with Teams Error

How to Fix Microsoft Edge Not Working with Teams Error

Tired of the frustrating Microsoft Edge "Not Working with Teams" error? Discover step-by-step fixes to get Microsoft Teams running smoothly in Edge. Quick, reliable solutions for seamless collaboration.

Troubleshooting Microsoft Teams Microsoft Error on Teams

Troubleshooting Microsoft Teams Microsoft Error on Teams

Tired of "Microsoft Error" crashing your Microsoft Teams? Discover step-by-step troubleshooting for Microsoft Teams errors, from cache clearing to advanced fixes. Get back to seamless collaboration today!

Troubleshooting Microsoft Teams Meeting Error 2026

Troubleshooting Microsoft Teams Meeting Error 2026

Stuck with Microsoft Teams Meeting Error 2026? Follow our proven troubleshooting Microsoft Teams "Meeting Error" 2026 steps for instant fixes. Get back to smooth meetings fast with the latest solutions.

Solving Microsoft Teams Installing Error on Windows Server

Solving Microsoft Teams Installing Error on Windows Server

Struggling with Microsoft Teams "Installing Error" on Windows Server? Discover proven, step-by-step fixes including MSI deployment, cache clearing, and PowerShell tweaks to resolve issues fast and get Teams running smoothly. Updated with latest methods.

Troubleshooting Microsoft Teams Voice and VOIP Errors

Troubleshooting Microsoft Teams Voice and VOIP Errors

Struggling with Microsoft Teams voice issues? Master troubleshooting Microsoft Teams voice and VOIP errors like no audio, echo, or choppy calls. Proven fixes for crystal-clear communication in Teams.

Fixing Microsoft Teams Download Failed Due to Unexpected Error

Fixing Microsoft Teams Download Failed Due to Unexpected Error

Tired of the frustrating Microsoft Teams download failed due to unexpected error? Discover quick, step-by-step fixes to resolve it fast and download Teams smoothly on Windows, Mac, or web. No tech skills needed!

How to Fix Microsoft Teams Network Error: Check Your Connection

How to Fix Microsoft Teams Network Error: Check Your Connection

Struggling with Microsoft Teams network error: Check Your Connection? Discover proven step-by-step fixes to restore seamless video calls, chats, and meetings. Quick troubleshooting for instant results.

Solving Microsoft Teams Video Error: Black Screen in Meetings

Solving Microsoft Teams Video Error: Black Screen in Meetings

Tired of Microsoft Teams black screen in meetings? Get proven, step-by-step solutions to solve the video error instantly. From quick fixes to advanced tweaks—regain seamless video calls today!

Troubleshooting Microsoft Teams DLL Error Missing File

Troubleshooting Microsoft Teams DLL Error Missing File

Tired of Microsoft Teams crashing with DLL Error? Discover proven troubleshooting steps for missing DLL files like VCRUNTIME140.dll. Get Teams running smoothly in minutes—no tech skills needed!

Microsoft Teams vs Zoom: Comparing Features for Webinars

Microsoft Teams vs Zoom: Comparing Features for Webinars

Discover Microsoft Teams vs Zoom webinar features head-to-head: capacity, interactivity, security, pricing & more. Find the best platform for your next big webinar in this detailed comparison.