List of common shortcuts for Google Sheets on Chrome OS (Part 3)

In the previous section Network Administrator has introduced to you the list of common shortcuts for Google Sheets on computers, Macbooks. The following article Network administrator will introduce to you the list of common shortcuts for Google Sheets on Google Chrome OS browser so you can better understand how to use Google Sheets.

1. General shortcut keys

Select column: Ctrl + Space

Select row: Shift + Space

Select all: Ctrl + A or Ctrl + Shift + Space

Hide the selected background cell: Ctrl + Shift + Backspace

Back (Undo): Ctrl + Z

Repeat the operation (Redo): Ctrl + Y or Ctrl + Shift + Z or F4

Search: Ctrl + F

Search and replace: Ctrl + H

Fill range: Ctrl + Enter

Fill down: Ctrl + D

Fill right: Ctrl + R

Save: Ctrl + S

Open saved file: Ctrl + O

Print: Ctrl + P

Copy (Copy): Ctrl + C

Cut: Ctrl + X

Paste: Ctrl + V

Paste value: Ctrl + Shift + V

Display keyboard shortcuts: Ctrl + /

New insert sheet: Shift + F11

Adjust Compact: Ctrl + Shift + F

Open / off Input tool: Ctrl + Shift + K

Select Input tool: Ctrl + Alt + Shift + K

2. Shortcut cell format

Bold: Ctrl + B

Underline: Ctrl + U

Italic: Ctrl + I

Dash: Alt + Shift + 5

Center: Ctrl + Shift + E

Left align : Ctrl + Shift + L

Right align : Ctrl + Shift + R

Format cell borders, upper table borders: Alt + Shift + 1

Format cell borders, right panel borders: Alt + Shift + 2

Format cell borders, border table below: Alt + Shift + 3

Format cell borders, border on left panel: Alt + Shift + 4

Delete border format: Alt + Shift + 6

Formatting cell borders, outboard table borders: Alt + Shift + 7

Insert Hyperlink link: Ctrl + K

Insert time: Ctrl + Shift +;

Insert date: Ctrl +;

Ctrl + Shift + 1 : Decimal format

Ctrl + Shift + 2: Time format

Ctrl + Shift + 3 : Date format

Ctrl + Shift + 4: Format the number of Curency type with two decimal places

Ctrl + Shift + 5: Digital format of Percentage style (without decimal digits)

Ctrl + Shift + 6: Number format of Exponential type with two decimal places

Ctrl +: Delete the format

3. Spreadsheet navigation shortcut

Move to the beginning of the row: Ctrl + left arrow

Move to the top of the table: Ctrl + Search + left arrow

Move to end of row: Ctrl + right arrow

Move to the end of the table: Ctrl + Search + right arrow

Move to the working cell: Ctrl + Backspace

Display table list: Alt + Shift + K

Open Hyperlink link: Alt + Enter

Move the Focus out of Spreadsheet: Ctrl + Alt + Shift + M

Move to Quicksum: Alt + Shift + Q

Move Focus to Popup Menu: hold down Ctrl + Alt , press E and press P

Open Menu to filter cell data: Ctrl + Alt + R

Open history: Ctrl + Alt + Shift + G

Open the chat inside the Spreadsheet: Shift + Esc

Close the drawing editor: Shift + Esc or Ctrl + Esc

4. Shortcuts to edit comments and likes

Insert / edit comments: Shift + Search + F2

Insert / edit comments: Ctrl + Alt + M

Open discussion topic: Ctrl + Alt + Shift + A

Enter the current caption: hold down Ctrl + Alt , press E and press C

5. Shortcut to open Menu

Open Edit Menu:Alt + E

Open the View Menu: Alt + V

Open Insert Menu: Alt + I

Open Menu Format: Alt + O

Open Data Menu: Alt + D

Open Menu Tool: Alt + T

Open the Form Menu: Alt + M

Open Add-ons Menu: Alt + N

Open Menu Help: Alt + H

Open the Accessibility Menu: Alt + A

Open Menu Sheet: Ctrl + Shift + S

Open Context Menu: Ctrl + Shift +

6. Shortcuts use insert or delete rows / columns

Insert the row above: hold down Alt + I, then press R

Insert the bottom row: hold down Alt + I , then press W

Insert left column: hold Alt + I , then press C

Insert the right column: hold down Alt + I, then press G

Delete rows: hold down Alt + E , then press D

Delete column: hold down Alt + E , then press E

7. Shortcuts to use open formulas

Show all formulas: Ctrl + ~

Insert array formula (Array formula): Ctrl + Shift + Enter

Collapse array formula extensions (array formula): Ctrl + E

Show / hide the formula support menu: Shift + Search + 1

8. Shortcuts support screen reading

Activate screen reading text mode: Ctrl + Alt + Z

Read the text in the column: Ctrl + Alt + Shift + C

Read the text in the row: Ctrl + Alt + Shift + R

Explore more:

Summary - 38 'priceless' shortcuts in Microsoft Excel
220 shortcut keys on Excel for Windows and Mac OS
List of common shortcuts for Google Sheets on computers (Part 1)

Having fun!

Samuel Daniel

Update 25 May 2019

You should read it

May be interested

Summary of shortcuts on Chrome browser for Windows computer users
google chrome is still the preferred browser of many users on computers as well as smartphones, but not everyone knows how to use shortcuts, please refer to the article to use chrome effectively. and more speed.
30 shortcuts for IE, Firefox and Google Chrome
using shortcuts on web browsers not only saves you a lot of time in browsing and accessing websites but also helps your hands manipulate more on the keyboard instead of just using the mouse. in the article below, we will synthesize 30 useful and convenient shortcuts on the three most popular browsers today: internet expoler (ie), firefox and google chrome.
Keyboard shortcuts for Chrome - Summary of Chrome shortcuts you need to know
for people who often use google chrome, the keyboard shortcuts will help them work faster and save a lot of time. in this article, software tips will send you the extremely useful shortcuts on google chrome.
How to add bullet in Google Sheets
to add a list of forms in google sheets, the user will do it via a shortcut or by the command.
How to insert checkboxes on Google Sheets
adding checkboxes to optional list data on google sheets makes it easier for users to manage content.
How to turn off shortcuts on Google Chrome
keyboard shortcuts on chrome will help you perform quick operations. so what if i want to turn off the shortcut on chrome?
Tricks using Google Sheets should not be ignored
google sheets is now considered an online version of microsoft excel and is widely used by many people. we can conduct online data storage, perform calculations like when used with excel.
How to create graphs, charts in Google Sheets
google sheets also features a graphical representation, showing the data that are included so that users can change the chart.
How to Fix Google Sheets 'Still loading ...' error in Chrome
there are many causes of the google sheets 'still loading' error on chrome, possibly because the extension you installed on your browser, the browser version you are using is out of date, here are 5 ways to fix it. google sheets 'still loading' error in chrome.
5 reasons you should give up Excel and start using Google Sheets
google sheets is a spreadsheet web application that works as part of the google docs toolkit. google sheets was released in 2006, nearly two decades after the first release of microsoft excel.