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

Live Drawing: Final Cut Pro feature on iPad makes your videos more personal

Live Drawing: Final Cut Pro feature on iPad makes your videos more personal

Adding your own handwriting or artwork to your videos instantly makes them more personal and authentic. With Final Cut Pro on iPad, it's easier than ever.

How to hide all photos on Facebook

How to hide all photos on Facebook

Depending on each person's needs, we can hide albums on Facebook, or hide photo posts on Facebook. After you hide all photos on Facebook, others cannot see those photos.

Open notifications on Samsung in Split Screen view or pop-up window

Open notifications on Samsung in Split Screen view or pop-up window

You may know that Android phones can open two apps at once in Split Screen view. This is one of many Android features that can help you stay productive.

Latest Goose Goose Duck Code 4/2025

Latest Goose Goose Duck Code 4/2025

Collect the full set of Goose Goose Duck giftcodes today to unlock exciting costumes and items.

Latest Pirate King Legend Giftcode and how to redeem code

Latest Pirate King Legend Giftcode and how to redeem code

PirateKingLegend Giftcode that the developer released is for players when they first take their first steps in Dai Hai Trinh.

Nvidia releases DLSS 4 plugin for Unreal Engine 5, whats noteworthy?

Nvidia releases DLSS 4 plugin for Unreal Engine 5, whats noteworthy?

In January this year, Nvidia launched the latest generation of RTX 50 series graphics cards, and introduced the fourth version of Deep Learning Super Sampling (DLSS) technology to users.

How to create rounded corner images in Photoshop

How to create rounded corner images in Photoshop

Rounding the corners of an image in Photoshop is very simple, and you can choose the level of rounding the corners of the image.

Latest Mobile Legends Codes 4/2025

Latest Mobile Legends Codes 4/2025

Discover the latest Mobile Legends giftcodes to get attractive gifts completely free.

How to adjust CS 1.1 buttons, fix Half Life buttons

How to adjust CS 1.1 buttons, fix Half Life buttons

This is the easiest and most familiar way to adjust CS 1.1 buttons for many gamers. In addition, you can also edit function keys or actions depending on your playing habits.

Intel Graphics Software Launched: Comprehensive Toolkit for Managing Intel Graphics Cards

Intel Graphics Software Launched: Comprehensive Toolkit for Managing Intel Graphics Cards

Intel calls the new Intel Graphics Software application an “all-in-one utility that helps users optimize games, download new graphics drivers, and adjust driver settings on a game-by-game basis.

OpenAI Announces ChatGPT Pro Plan for a whopping $200 per month

OpenAI Announces ChatGPT Pro Plan for a whopping $200 per month

OpenAI currently offers four ChatGPT subscription levels to meet the needs of different customer groups.

Beautiful plants and flowers contain deadly poison

Beautiful plants and flowers contain deadly poison

Poisonous flowers are not rare in the world. This article will summarize for you poisonous flowers that have beautiful appearance but can be deadly.

Admire the beautiful images of Earth taken by the Blue Ghost spacecraft

Admire the beautiful images of Earth taken by the Blue Ghost spacecraft

It's been a week since Firefly Aerospace's Blue Ghost mission began its journey to the Moon, carrying NASA's scientific instruments and aiming to perform the second commercial soft landing on the planet's surface.

HDR on phones can be useless

HDR on phones can be useless

Turning off the phone's HDR results in unimpressive, inconsistent results and is a feature that's often not important.

Valuable Excel shortcuts you should know

Valuable Excel shortcuts you should know

If you can master the formulas, shortcut keys on Excel will be much faster and more convenient. Let's join WebTech360 to collect for yourself the invaluable Excel shortcut keys in the summary below.