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

5 Reasons Why Users Dont Use WhatsApps Meta AI Button, Despite Its Usefulness

5 Reasons Why Users Dont Use WhatsApps Meta AI Button, Despite Its Usefulness

Meta's new AI button is appearing in WhatsApp chats, offering a quick way to interact with its AI assistant. While it may seem useful, there are a few key reasons why many people choose not to use it.

Is armpit itching a warning sign of cancer?

Is armpit itching a warning sign of cancer?

Itchy armpits are often caused by a skin condition. But certain health conditions, including some types of cancer, can cause itchy armpit rashes and other symptoms.

What is the disease of spontaneous nosebleed?

What is the disease of spontaneous nosebleed?

When you have a nosebleed, it can be related to medications, health conditions, or simply dry air. Here's what you need to know about nosebleeds.

4 VPNs That Dont Require Login or Registration

4 VPNs That Dont Require Login or Registration

Want to get the benefits of a VPN without signing up for an account? Believe it or not, there are options out there.

Latest Code for Sword Sweep Eight Desolations and how to redeem the code

Latest Code for Sword Sweep Eight Desolations and how to redeem the code

Code Piu Piu Master gives players a series of attractive rewards such as Gems, Gold, and Treasure Lock.

Tips for organizing Gmail tasks on Android and iPhone extremely professionally

Tips for organizing Gmail tasks on Android and iPhone extremely professionally

The Gmail app on Android offers a number of powerful features that can save you time, organize your inbox, and help you manage your email more efficiently.

How to Use Canva AI to Create Business Cards

How to Use Canva AI to Create Business Cards

You can use Canva's Magic Design, Magic Media, Magic Write, and Canva Print for your business card project.

The most bizarre birds, some seem to travel to Earth from another world

The most bizarre birds, some seem to travel to Earth from another world

Let's admire the beauty of birds with unique and strange appearances, as if they have traveled to Earth from another world.

Latest Code of Three Kingdoms Running Running Running

Latest Code of Three Kingdoms Running Running Running

Code Tam Quoc Run Run Run is an indispensable gift exchange procedure before you participate in running matches to destroy the aggressive crowds surrounding you.

Latest Long Ngu Suong Thanh Code and how to redeem code

Latest Long Ngu Suong Thanh Code and how to redeem code

Redeem Long Ngu Suong Thanh giftcode below to receive valuable rewards such as heroes, food, diamond chests...

Fishing Simulator Code, Fishing Fever Code and How to Enter

Fishing Simulator Code, Fishing Fever Code and How to Enter

Fishing Simulator code may expire but the expiration date is unknown. So please check Fishing Simulator code in this article regularly.

13 beautiful and stylish short female hairstyles

13 beautiful and stylish short female hairstyles

Below are the most beautiful, individual short female hairstyles that also help to "hack" age, which are most loved by women today.

Solar storms are creating stunning auroras around the world

Solar storms are creating stunning auroras around the world

The period from October 6 to 13 is an exciting week for the skywatching community, as stunning auroras are visible in many locations around the world.

What to do when you have trouble sleeping?

What to do when you have trouble sleeping?

Prioritizing a consistent sleep schedule and evening routine can help improve the quality of your sleep. Here's what you need to know to stop tossing and turning at night.

7 ways to number pages in Word that you need to know

7 ways to number pages in Word that you need to know

There are many ways to number pages in Word for us to choose from, depending on the requirements for numbering pages in Word.