List of common shortcuts for Google Sheets on computers (Part 1)

Using Google Docs shortcuts makes it easy to understand how to use Google Docs, edit and edit documents faster. Google Sheest is similar, using Google Sheets shortcuts to help you enter data faster and more efficiently, especially saving time. Below is a list of common shortcuts for Google Sheets on your computer.

Explore more:

Summary - 38 'priceless' shortcuts in Microsoft Excel

10 ways to use the Paste feature in Excel

Calculate the total value of the filtered list in Excel

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 +

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: C trl + 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 +;

Decimal format: Ctrl + Shift + 1

Time format: Ctrl + Shift + 2

Date format: Ctrl + Shift + 3

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

Number format Percentage type (no decimal digits): Ctrl + Shift + 5

Exponential type number format with two decimal digits: Ctrl + Shift + 6

Delete format: Ctrl +

3. Spreadsheet navigation shortcut

Move to surrender: Home

Move to the top of the table: Ctrl + Home

Move to the end of the row: End

Move to the end of the table: Ctrl + End

Move to the working cell: Ctrl + Backspace

Move to the next table: Ctrl + Shift + Page Down

Move to the previous table: Ctrl + Shift + Page Up

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

4. Shortcuts to edit comments and likes

Insert / edit captions: Shift + 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

Move to the next comment: hold down Ctrl + Alt, press N and press C

Move back to the previous comment: hold down Ctrl + Alt , press P and press C

5. Shortcut to open Menu

Open File Menu :

On Google Chrome browser: Alt + F

Other browser: Alt + Shift + F

Open Edit Menu:

On Google Chrome browser: Alt + E

Other browser: Alt + Shift + E

Open the View Menu:

On Google Chrome browser: Alt + V

Other browser: Alt + Shift + V

Open Insert Menu:

On Google Chrome browser: Alt + I

Other browser: Alt + Shift + I

Open Menu Format:

On Google Chrome browser: Alt + O

Other browser: Alt + Shift + O

Open Data Menu:

On Google Chrome browser: Alt + D

Other browser: Alt + Shift + D

Open Menu Tool :

On Google Chrome browser: Alt + T

On another browser: Alt + Shift + T

Open Menu Form:

On Google Chrome browser: Alt + M

Other browser: Alt + Shift + M

Open the Add-ons Menu:

On Google Chrome browser: Alt + N

Other browser: Alt + Shift + N

Open Help Menu:

On Google Chrome browser: Alt + H

Other browser: Alt + Shift + H

Open the Accessibility Menu:

On Google Chrome browser: Alt + A

Other browser: Alt + Shift + A

Open Menu Sheet: Alt + Shift + S

Open Context Menu: Ctrl + Shift +

6. Shortcuts use insert or delete rows / columns

Insert row on:

On Google Chrome browser: hold down Alt + I , then press R

On another browser: hold down Alt + Shift + I , then press R

Insert row below:

On Google Chrome browser: hold down Alt + I , then press W

Other browser: hold down Alt + Shift + I, then press W

Insert left column:

On Google Chrome browser: hold down Alt + I , then press C

Other browser: hold down Alt + Shift + I , then press C

Insert the right column:

On Google Chrome browser: hold down Alt + I , then press G

Other browser: hold down Alt + Shift + I, then press G

Delete row:

On Google Chrome browser: hold down Alt + E, then press D

Other browser: hold down Alt + Shift + E , then press D

Delete column:

On Google Chrome browser: hold down Alt + E , then press E

Other browser: hold down Alt + Shift + 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 recipe support menu: Shift + F1

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

The next section of Network Administration will introduce you to the common shortcut list for Google Sheets on Mac.

Having fun!

Isabella Humphrey

Update 25 May 2019

You should read it

May be interested

List of common shortcuts for Google Sheets on Mac (Part 2)
using keyboard shortcuts to import data into a table makes it easy to understand how google sheets uses it to help you work faster and more efficiently. in the next section, network administrator will introduce you to the list of common google sheets shortcuts on mac.
List of common shortcuts for Google Sheets on Chrome OS (Part 3)
google sheets consists of worksheets, each sheet consists of multiple cells created by rows and columns, the toolbar supports basic tools such as formatting sheets, cells, text, inserting charts, images, ... .
List of common shortcuts for Google Sheets on Android (Last part)
the interface and working style of google sheets is similar to excel, even simpler. using keyboard shortcuts helps you enter table data smarter and faster.
How to create Bookmark for PDF file?
every day, you have to work with a lot of pdf document pages and often take a lot of time in finding the right file you need. therefore, a good solution in this case is to create a bookmark. like on web browsers, foxit reader also allows you to create bookmarks to re-mark them for later retrieval. moreover, you can sort them by table of contents for convenient search and editing as needed.
Instructions for changing the default PDF file reader application in Windows 10
if you want to change another program in your computer to open the pdf file instead of using edge in windows 10. in the following article, network administrator will introduce and guide you in two extremely simple ways.
Trick to quickly delete a table in Word
to delete a table in word is not as simple as you think. if you use the usual delete key to delete, it cannot be deleted. in the article below, network administrator will show you how to delete a table in word.