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

Apple allows users to stay on iOS 15.7 before upgrading to iOS 16

Apple allows users to stay on iOS 15.7 before upgrading to iOS 16

Apple allows users to stay on iOS 15 while still receiving security updates before upgrading to iOS 16.

Intel Core Ultra 5 225H, Core Ultra 7 255H and Core Ultra 9 285H CPU performance evaluation results are available on Geekbench

Intel Core Ultra 5 225H, Core Ultra 7 255H and Core Ultra 9 285H CPU performance evaluation results are available on Geekbench

Three SKUs from Intel's upcoming Arrow Lake-H mobile lineup have been tested on Geekbench, revealing pretty impressive single-core and multi-core performance and specifications.

Who would have thought that the process of producing familiar rubber bands is so complicated and elaborate?

Who would have thought that the process of producing familiar rubber bands is so complicated and elaborate?

Those little rubber bands look simple, but the process of making them is more complicated than you might think. Here’s the complete process of making rubber bands.

9 interesting facts about Mercury

9 interesting facts about Mercury

Mercury is the smallest planet in the Solar System and also the closest planet to the Sun. Mercury orbits the Sun at an incredibly fast speed, averaging nearly 106,000 miles per hour. These are just a few of the many interesting facts about this planet.

What are the sizes of 32-inch, 40-inch, 43-inch, 55-inch TVs... from Sony, Samsung, LG?

What are the sizes of 32-inch, 40-inch, 43-inch, 55-inch TVs... from Sony, Samsung, LG?

The article below will help you understand the sizes of current TV lines from Sony, Samsung, and LG so you can make the right purchase decision.

7 Simple Tech Tweaks That Dramatically Improve Your Quality of Life

7 Simple Tech Tweaks That Dramatically Improve Your Quality of Life

Creating a healthy relationship with technology can seem daunting, but small changes often make a big difference.

8 Things You Didnt Know You Could Do in the Samsung Gallery App

8 Things You Didnt Know You Could Do in the Samsung Gallery App

Samsung's Gallery app is more capable than you might think, but that might not be immediately obvious.

Microsofts foldable smartphone wont have a crease

Microsofts foldable smartphone wont have a crease

Microsoft is said to be getting closer to launching its first foldable smartphone when it was granted a patent for a foldable phone with the ability to fold 360 degrees but without creating wrinkles on the screen on October 1.

Google testing blue checkmark in search

Google testing blue checkmark in search

Google is testing a new verification feature through a blue checkmark in search that will help users avoid clicking on fake or fraudulent website links.

Distinguishing Microsoft 365 and Office 2024

Distinguishing Microsoft 365 and Office 2024

At first glance, Microsoft 365 and Office 2024 may seem very similar, as they both give you access to Microsoft's popular and widely used applications.

Latest Elemental Dungeons Codes and How to Enter Codes

Latest Elemental Dungeons Codes and How to Enter Codes

Elemental Dungeons codes are a necessary form of reward for gamers. Like any other online game on Roblox, players can receive these aids in exchange for money or other items.

How to repeat table title bar in Word

How to repeat table title bar in Word

When you print a Word document, create a table in Word, repeating the title in Word helps us track the title more conveniently, read the document title seamlessly across different pages, especially with long titles.

How to create animated messages on iMessage iOS 18

How to create animated messages on iMessage iOS 18

The new iOS 18 iMessage is updated with animated messages, text effects with many options to use for the messages you send.

Why are pigs the nemesis of snakes?

Why are pigs the nemesis of snakes?

There is an interesting fact about pigs that not everyone knows: pigs are considered the enemy of snakes, because when these two animals meet, most snakes will become food for pigs.

What is the distance from Earth to Jupiter - the largest planet in the Solar System?

What is the distance from Earth to Jupiter - the largest planet in the Solar System?

How far is Jupiter from Earth? If you don't know, this article will tell you how far Jupiter is from Earth.