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!
You should read it
- List of common shortcuts for Google Sheets on Android (Last part)
- Insert line shortcut in Excel - Shortcut insert Excel
- List of common shortcuts for Google Sheets on Chrome OS (Part 3)
- Shortcut switch Sheet in Excel
- How to display 0 in front of a number in Excel
- Shortcut guide, abbreviated in Excel
- Newline shortcut in Excel
- List of common Mac shortcuts
May be interested
- How to add bullet in Google Sheetsto 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 Sheetsadding checkboxes to optional list data on google sheets makes it easier for users to manage content.
- Tricks using Google Sheets should not be ignoredgoogle 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 Sheetsgoogle sheets also features a graphical representation, showing the data that are included so that users can change the chart.
- 5 reasons you should give up Excel and start using Google Sheetsgoogle 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.
- How to open and create Google Docs with keyboard shortcutssuite shortcuts utility will create files docs, google slides, google sheets via shortcuts that we do not need to go directly to the application as before.
- How to align spreadsheets before printing on Google Sheetsbefore printing spreadsheet data on google sheets, users should adjust the data sheet before printing to get a better layout.
- Summary of useful shortcuts on Google Driveif you regularly store your documents from documents, images, videos, etc. on cloud storage tools, do not ignore the list of common shortcuts.
- Google Drive for creating quick access shortcuts from the desktopto make it easier for users, google has just released a new google drive update that creates shortcuts to docs, sheets, and slides document types right on the user's desktop.
- 4 Google Script makes Google Sheets more powerfulgoogle sheets is part of google suite and is by far one of the most powerful free tools. what makes this tool even more powerful is the use of google script to enhance the capabilities of google sheets.