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

Pros and Cons of Enabling VPN at the Router Level

Pros and Cons of Enabling VPN at the Router Level

While many of us use VPNs directly on our devices, you can also enable VPNs at the router level. This setup eliminates the need to connect each device individually.

Dont buy these 5 smartphone photography gadgets!

Dont buy these 5 smartphone photography gadgets!

Buying a lot of add-ons may make you feel more professional, but buying the wrong thing won't improve your photography.

Thinking there was no way out, the wildebeest unexpectedly defeated the lion

Thinking there was no way out, the wildebeest unexpectedly defeated the lion

A video shows a wildebeest being held down by a lion. It seems the antelope’s fate has been sealed, everyone thinks it is just waiting to die.

Heart-Healthy Snacks

Heart-Healthy Snacks

Choosing heart-healthy snacks can add extra nutrition to your diet and help keep you energized and full between meals.

Simple way to fix computer suddenly shut down

Simple way to fix computer suddenly shut down

If unfortunately, you are using the computer and suddenly it turns off. You are wondering what is wrong with your computer? This article will guide you how to fix this error.

How to delete reading list on Safari

How to delete reading list on Safari

Over time, as you use your reading list in Safari more often, it can get large and cluttered. Here's how to clear your reading list in Safari.

How to create a Telegram group topic for discussion

How to create a Telegram group topic for discussion

Telegram group topics will be separate from messages in the Telegram group and you can create many different discussion topics. The article below will guide you to create Telegram group topics.

Tesla coil can discharge electricity and sing

Tesla coil can discharge electricity and sing

The Tesla coil is a resonant transformer circuit, a famous invention of the brilliant genius Nikola Tesla. It is used to produce high voltage, low intensity, high frequency alternating current... Not only discharge electricity, with intelligence and creativity, people also make Tesla coils sing.

Moving a 220-ton ancient building with 700 bars of soap

Moving a 220-ton ancient building with 700 bars of soap

In early December, construction company S. Rushton successfully moved an ancient building weighing up to 220 tons in Halifax, Nova Scotia, Canada, a distance of 9 meters with the "help" of about 700 bars of soap.

Supersonic engine reaches speed of 19,756 km/h

Supersonic engine reaches speed of 19,756 km/h

Chinese hypersonic weapons researchers create the world's most powerful rotary-explosive engine that allows aircraft to travel at 19,756 km/h (Mach 16) at an altitude of 30 km.

Status to wish yourself a happy birthday in English

Status to wish yourself a happy birthday in English

Below are some statuses to wish yourself a happy birthday in English, happy birthday wishes in English for yourself that are good and meaningful, please refer to them.

1 liter equals how many ml, kg, m3?

1 liter equals how many ml, kg, m3?

How many ml is 1kg? How many kg is 1ml? Let's learn how to convert these units of weight!

AI animal translation helps humans understand dog barking

AI animal translation helps humans understand dog barking

Thanks to artificial intelligence (AI), what seems like a movie dream - humans being able to understand animal language - may soon become a reality.

What do the camera settings on your phone do?

What do the camera settings on your phone do?

Knowing what each feature does can make the difference between a good photo and a great photo.

CapCut Pro Price: How Much Does CapCut Cost? Choosing the Best Version for You!

CapCut Pro Price: How Much Does CapCut Cost? Choosing the Best Version for You!

Discover the CapCut price, features of the free and Pro versions, and a detailed comparison to help you decide which CapCut subscription is right for your video editing needs.