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

Named return parameters in Golang

Named return parameters in Golang

In Golang, named return parameters are often referred to as named parameters. Golang allows naming the return parameters or results of functions in the function signature or definition.

Instructions for setting chat wallpaper on WhatsApp

Instructions for setting chat wallpaper on WhatsApp

WhatsApp has a chat wallpaper changer feature that allows users to set chat themes on WhatsApp. Users can choose from 30 different wallpapers for their chats, or use their personal photos to set chat wallpapers on WhatsApp.

What is FLV file? How to open FLV file on computer?

What is FLV file? How to open FLV file on computer?

You often download videos from the Internet to your computer to watch offline and often see FLV files. Are you struggling to know how to open them? Today, we will provide information about FLV video files for you in the article below.

How to view news archive on Facebook phone, computer

How to view news archive on Facebook phone, computer

To review Facebook posts, you need to enable Facebook's news archive. All Facebook posts after enabling archive mode will be saved in the archive for you to review whenever you need.

Latest MU Luc Dia VNG Code and how to redeem code

Latest MU Luc Dia VNG Code and how to redeem code

You can exchange MU Luc Dia VNG game codes for Zen and other currencies.

10 indispensable apps for book lovers

10 indispensable apps for book lovers

Just because you don't have a book on you doesn't mean you have to stop reading. All you need is your phone to try out social media apps for book lovers and find the next book you want to read.

Learn About Spotify Connect: The Spotify Feature Thats Forced Users to Quit YouTube Music

Learn About Spotify Connect: The Spotify Feature Thats Forced Users to Quit YouTube Music

The ability to control music playing on one device from another is an underrated feature that YouTube Music doesn't have — and that forces people to turn to Spotify.

How to Make a Snowball Explode in Minecraft Bedrock & Java Editon

How to Make a Snowball Explode in Minecraft Bedrock & Java Editon

Minecraft commands allow players to create many interesting effects and one interesting option is to make snowballs explode. Here is how to make snowballs explode in Minecraft.

Does Your PC Have an NPU? Heres How to Check

Does Your PC Have an NPU? Heres How to Check

On Windows 11, you can quickly check if your computer has an NPU (Neural Processing Unit), through 3 very simple ways.

Is Hibernate mode bad for PC?

Is Hibernate mode bad for PC?

Hibernate mode was born out of the need to keep the computer on 24/7 without wanting to drain the battery or to ensure the system is not affected by power failure, unlike the case of Sleep mode.

Instructions to add Euro 2024 calendar on iPhone

Instructions to add Euro 2024 calendar on iPhone

Adding the Euro 2024 calendar on iPhone helps users easily follow matches within the framework of Euro 2024, a football tournament with exciting matches.

Summary of information about Samsung One UI 7

Summary of information about Samsung One UI 7

Samsung Galaxy phones running One UI 7.0 will be more secure with Lockdown Mode, preventing unauthorized attacks.

How to create poster effect for photos in Photoshop

How to create poster effect for photos in Photoshop

Add a quick and easy poster effect to your images using Photoshop to recreate the classic look of posters printed with limited ink colors.

How to switch between old Outlook and new Outlook

How to switch between old Outlook and new Outlook

Not everyone is familiar with the new Outlook interface and wants to go back to the old Outlook to use the full features and more customizations on Outlook. Below is a guide to switch between the old Outlook and the new Outlook.

Learn About Organic Maps: An Open Source Alternative to Google Maps

Learn About Organic Maps: An Open Source Alternative to Google Maps

Organic Maps is a free, open-source mapping app for Android and iOS, developed by the same team behind MapsWithMe, first launched in 2011.