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.
Sign up and earn $1000 a day ⋙

Leave a Comment

Download the new Google Pixel wallpapers celebrating Hispanic Heritage Month

Download the new Google Pixel wallpapers celebrating Hispanic Heritage Month

These are Google Pixel wallpapers celebrating Hispanic Heritage month, and they're a little more abstract than what we're used to seeing from other Pixel wallpapers.

How to record short videos on Xiaomi Redmi 10

How to record short videos on Xiaomi Redmi 10

On Xiaomi Redmi 10, there is a short video recording feature so you can record videos and post them on Instagram Story or Facebook Story without having to use additional editing applications.

How to Enable Dark Mode in Notepad on Windows 10/11

How to Enable Dark Mode in Notepad on Windows 10/11

Windows comes with a dark theme that improves the overall aesthetics of the system. However, this option is limited and does not affect certain applications.

8 Useful Samsung Apps That Dont Come Pre-Installed on Galaxy Phones

8 Useful Samsung Apps That Dont Come Pre-Installed on Galaxy Phones

While you may be familiar with the pre-installed apps, there are a number of lesser-known but equally valuable apps that Samsung offers.

Apple is not perfect anymore

Apple is not perfect anymore

The attention to detail that once set Apple apart seems to be lacking, and many are starting to think about taking their tech ecosystem elsewhere.

4 Simple Ways to Fix Plex Streaming Problems

4 Simple Ways to Fix Plex Streaming Problems

Plex streaming issues are particularly frustrating. And while setting up a Plex server is pretty straightforward, there are always times when you need to troubleshoot streaming issues with your Plex setup.

Bleach Rebirth of Souls PC Configuration

Bleach Rebirth of Souls PC Configuration

Bleach: Rebirth of Souls is an action fighting game based on the hit anime and manga series Bleach.

Remote Desktop Connection: Detailed setup instructions, 100% successful computer access via the Internet

Remote Desktop Connection: Detailed setup instructions, 100% successful computer access via the Internet

Quantrimang.com will guide you on how to use Remote Desktop to access your computer via the Internet on Windows 10 in the most detailed way.

The latest Sword God Is Me code and how to redeem the code

The latest Sword God Is Me code and how to redeem the code

Sword God Is Me gives all players a series of rewards in giftcode, this is definitely a procedure that players cannot ignore when first entering the game.

Latest Tran Ma Khuc Code and how to redeem code

Latest Tran Ma Khuc Code and how to redeem code

Funtap gives players locked KNB, Hoan Linh An, Ngan Bao, rare Linh Thu... through giftcode Tran Ma Khuc.

Apple Intelligence Blocked on All Meta Apps on iOS

Apple Intelligence Blocked on All Meta Apps on iOS

Apple Intelligence is an artificial intelligence (AI) system developed by Apple specifically for its devices including iPhone, iPad and Mac.

Nvidias Latest Update Will Make Your GPU Look Like New

Nvidias Latest Update Will Make Your GPU Look Like New

If you haven’t updated your Nvidia GPU in a while, now’s a good time. The company’s latest driver update addresses a number of long-standing bugs while also delivering significant performance gains.

LG Smart TVs Will Soon Be Able to Track Users Emotions to Show More Ads

LG Smart TVs Will Soon Be Able to Track Users Emotions to Show More Ads

Upcoming LG TVs will now use AI models to analyze users' emotions and show them even more ads.

How to disable Office file viewer in Microsoft Edge

How to disable Office file viewer in Microsoft Edge

The Edge browser has a rather annoying feature that opens Office documents immediately instead of downloading them to your device for later viewing. Here's how to disable the Office file viewer on Edge.

5 websites to help prank your friends with fake emails

5 websites to help prank your friends with fake emails

If you want to send fake emails to prank your friends and family, there are a number of online services worth exploring.