Ask a Question

Summary of Google Sheets shortcuts

+4 votes
189 views
in Sell ​​on the Internet by (242k points)
reopened
Summary of Google Sheets shortcuts

1 Answer

+5 votes
by (1.6m points)
edited
 
Best answer

Google Sheets Shortcuts for Windows and Mac Users
Access the list of keyboard shortcuts directly in Google Sheets
Use supported shortcuts in Google Sheets
Google Sheets shortcuts: general keyboard shortcuts for Google Sheets
Formatting key combinations in Google Sheets
Keyboard shortcuts for navigating Google Sheets
Google Sheets shortcuts for notes and comments
Shortcuts to open menus in Google Sheets
Keyboard shortcuts in Google Sheets to add or delete rows and cells
Google Sheets shortcuts for formulas
Screen Reader Help Google Sheets Shortcuts
image

Summary of Google Sheets shortcuts

Whether you need to record your work time or have to do calculations or plan projects, the Google spreadsheet editing program (in English: Google Sheets) of G Suite offers several very practical uses in the day-to-day of a company. All spreadsheets are automatically connected to your Google account, so you can access your files anytime, anywhere, even with your smartphone..

There are different keyboard shortcuts that make working on Google Sheets easier. In fact, in theory, you could create and edit spreadsheets without using the mouse once. We have compiled a list of the most useful shortcuts in Google Sheets and we will show you where you can access a list of all keyboard shortcuts in Google's own spreadsheet program . There you can not only search for any shortcut, but also activate compatible shortcuts from other spreadsheet editors (eg Microsoft Excel).

Index
  1. Google Sheets Shortcuts for Windows and Mac Users
    1. Google Sheets shortcuts: general keyboard shortcuts for Google Sheets
    2. Formatting key combinations in Google Sheets
    3. Keyboard shortcuts for navigating Google Sheets
    4. Google Sheets shortcuts for notes and comments
    5. Shortcuts to open menus in Google Sheets
    6. Keyboard shortcuts in Google Sheets to add or delete rows and cells
    7. Google Sheets shortcuts for formulas
    8. Screen Reader Help Google Sheets Shortcuts
  2. Access the list of keyboard shortcuts directly in Google Sheets
  3. Use supported shortcuts in Google Sheets

Google Sheets Shortcuts for Windows and Mac Users

We will start by introducing you to the most useful keyboard shortcuts so that you can edit and format your spreadsheets even more easily, regardless of whether you are a Windows or Mac user. We have also selected the most important combinations for navigating the table and using formulas within the Google spreadsheet editor..

advice

Looking for a complete Office solution? G Suite solutions from IONOS include all popular Google applications such as Gmail, Google Calendar, etc. and also Google Drive, Google Docs and Google Sheets, all in one package and with your own domain.

Google Sheets shortcuts: general keyboard shortcuts for Google Sheets

  Key combinations for Windows Key combinations for Mac
Select a column Ctrl + Space Ctrl + Space
Select a row Shift + Space Shift + Space
Select all Ctrl + ACtrl + Shift + Space ? + A? + Shift + Space
Undo Ctrl + Z ? + Z
Redo Ctrl + YCtrl + Shift + ZF4 ? + And? + Shift + ZFn + F4
Search for Ctrl + F ? + F
Find and replace Ctrl + H ? + Shift + H
Fill in the interval Ctrl + Enter ? + Return
Fill down Ctrl + D ? + D
Fill to the right Ctrl + R ? + R
Save (all changes are automatically saved to Drive) Ctrl + S ? + S
Open Ctrl + O ? + O
To print Ctrl + P ? + P
Copy Ctrl + C ? + C
Cut Ctrl + X ? + X
Paste Ctrl + V ? + V
Paste only the values Ctrl + Shift + V ? + Shift + V
Paste only the format Ctrl + Alt + V ? + Alt + V
Show common key combinations Ctrl + / ? + /
Insert a new sheet Shift + F11 Shift + Fn + F11
Hide controls Ctrl + Shift + F Ctrl + Shift + F
Enable or disable text input tools (available in spreadsheets in languages ​​with non-Latin characters) Ctrl + Shift + K ? + Shift + K
Select text input tools Ctrl + Alt + Shift + K ? + Option + Shift + K
Search in menus Alt + / Option + /

Formatting key combinations in Google Sheets

  Key combinations for Windows Key combinations for Mac
Bold font Ctrl + B ? + B
Underlined Ctrl + U ? + U
Italics Ctrl + I ? + I
Strikethrough Alt + Shift + 5 Option + Shift + 5
Center Ctrl + Shift + E ? + Shift + E
Align to the left Ctrl + Shift + L ? + Shift. + L
To align to the right Ctrl + Shift. + R ? + Shift. + R
Apply top edge Alt + Shift + 1 Option + Shift + 1
Apply right border Alt + Shift + 2 Option + Shift + 2
Apply bottom border Alt + Shift + 3 Option + Shift + 3
Apply left border Alt + Shift + 4 Option + Shift + 4
Remove the edges Alt + Shift + 6 Option + Shift + 6
Apply outer edge Alt + Shift + 7 Ctrl + Shift. + 7 Option + Shift + 7? + Shift. + 7
Insert a link Ctrl + K ? + K
Insert time Ctrl + Shift. +; ? + Shift. +;
Insert date Ctrl +; ? +;
Insert date and time Ctrl + Alt + Shift +; ? + Option + Shift +;
Format decimal Ctrl + Shift. +1 Ctrl + Shift. +1
Format time Ctrl + Shift. + 2 Ctrl + Shift. + 2
Format date Ctrl + Shift. + 3 Ctrl + Shift. + 3
Format currency Ctrl + Shift. + 4 Ctrl + Shift. + 4
Format percentage Ctrl + Shift. + 5 Ctrl + Shift. + 5
Format exponent Ctrl + Shift. + 6 Ctrl + Shift. + 6
Clear format Ctrl + \ ? + \

Keyboard shortcuts for navigating Google Sheets

  Key combinations for Windows Key combinations for Mac
Go to the front of the line Start Fn + left arrow
Go to the beginning of the sheet Ctrl + Home ? + Fn + left arrow
Go to the end of the line End Fn + right arrow
Go to the end of the sheet Ctrl + End ? + Fn + right arrow
Move to an active cell Ctrl + Backspace ? + Backspace
Go to the next sheet Alt + down arrow Option + down arrow
Go to the previous sheet Alt + up arrow Option + up arrow
Show sheet list Alt + Shift + K Option + Shift + K
Open a hyperlink Alt + Enter Option + Return
Open Explore Alt + Shift + X Option + Shift + X
Go to side panel Ctrl + Alt +. Ctrl + Alt +, ? + Option +.? + Option +,
Stop selecting spreadsheet Ctrl + Alt + Shift + M Ctrl +? + Shift + M
Go to quick sum (when a range of cells is selected) Alt + Shift + Q Option + Shift + Q
Select a popup (for links, bookmarks, and images) Holding Ctrl + Alt, press E then P Hold Ctrl +?, Press E then P
Open dropdown menu in filtered cell Ctrl + Shift + R Ctrl +? + R
Open revision history Ctrl + Alt + Shift. + H ? + Option + Shift + H
Open the chat within the spreadsheet Shift + Esc Shift + Esc
Close drawing editor Shift + Esc ? + Esc Shift + Esc

Google Sheets shortcuts for notes and comments

  Key combinations for Windows Key combinations for Mac
Insert or edit a note Shift + F2 Shift + F2
Insert or edit a comment Ctrl + Alt + M ? + Option + M
Open a comment conversation Ctrl + Alt + Shift. + A ? + Option + Shift + A
Go to current comment Holding Ctrl + Alt, press E then C Hold Ctrl +?, Press E then C
Go to next comment Holding Ctrl + Alt, press N then C Hold Ctrl +?, Press N then C
Go to previous comment Hold Ctrl + Alt, press P then C Hold Ctrl +?, Press P then C

Shortcuts to open menus in Google Sheets

  Key combinations for Windows Key combinations for Mac
Menu file Google Chrome: Alt + F Other browsers: Alt + Shift + F Ctrl + Option + F
Edit menu Google Chrome: Alt + E Other browsers: Alt + Shift + E Ctrl + Option + E
View Menu Google Chrome: Alt + V Other browsers: Alt + Shift + V Ctrl + Option + V
Insert menu Google Chrome: Alt + I Other browsers: Alt + Shift + I Ctrl + Option + I
Format menu Google Chrome: Alt + O Other browsers: Alt + Shift + O Ctrl + Option + O
Data Menu Google Chrome: Alt + D Other browsers: Alt + Shift + D Ctrl + Option + D
Tools menu Google Chrome: Alt + TO Other browsers: Alt + Shift + T Ctrl + Option + T
Open the Insert menu Ctrl + Alt + Shift + = Ctrl + Alt + = (with cells selected) ? + Option + = (with cells selected)
Open the menu? Delete? Ctrl + Alt + - (with cells selected) ? + Option + - (with cells selected)
Form menu (present when the spreadsheet is connected to a form) Google Chrome: Alt + M Other browsers: Alt + Shift + M Ctrl + Option + M
Plugins Menu Google Chrome: Alt + NO Other browsers: Alt + Shift + N Ctrl + Option + N
Help Menu Google Chrome: Alt + H Other browsers: Alt + Shift + H Ctrl + Option + H
Accessibility menu (appears when screen reader support is enabled) Google Chrome: Alt + A Other browsers: Ctrl + Shift + A Ctrl + Option + A
Sheet menu (copy, delete and perform other actions on the sheet) Alt + Shift + S Option + Shift + S
Contextual menu Ctrl + Shift. + \ ? + Shift + \

Keyboard shortcuts in Google Sheets to add or delete rows and cells

  Key combinations for Windows Key combinations for Mac
Insert rows above Ctrl + Alt + Shift + = Ctrl + Alt + = (with selected rows) Google Chrome: Alt + I, then R Other browsers: Alt + Shift + I, then R ? + Option + = (with rows selected) Ctrl + Option + I, then R
Insert rows below Google Chrome: Alt + I, then W Other browsers: Alt + Shift + I, then W Ctrl + Option + I, then B
Insert columns to the left Ctrl + Alt + Shift + = Ctrl + Alt + = (with selected columns) Google Chrome: Alt + I, then CO Other browsers: Alt + Shift + I, then C ? + Option + = (with columns selected) Ctrl + Option + I, then C
Insert columns to the right Google Chrome: Alt + I, then O Other browsers: Alt + Shift + I, then O Ctrl + Option + I, then O
Delete rows Ctrl + Alt + - (with rows selected) Google Chrome: Alt + E, then D Other browsers: Alt + Shift + E, then D ? + Option + - (with rows selected) Ctrl + Option + E, then D
Delete columns Ctrl + Alt + - (with columns selected) Google Chrome: Alt + E, then E Other browsers: Alt + Shift + E, then E ? + Option + - (with columns selected) Ctrl + Option + E, then E
Hide row Ctrl + Alt + 9 ? + Option + 9
Show row Ctrl + Shift. + 9 ? + Shift. + 9
Hide a column Ctrl + Alt + 0 ? + Option + 0
Show column Ctrl + Shift. + 0 ? + Shift. + 0
Group rows or columns Alt + Shift + right arrow Option + Shift + right arrow
Ungroup rows or columns Alt + Shift + left arrow Option + Shift + left arrow
Show grouped rows or columns Alt + Shift + down arrow Option + Shift + down arrow
Hide grouped rows or columns Alt + Shift + up arrow Option + Shift + up arrow

Google Sheets shortcuts for formulas

  Key combinations for Windows Key combinations for Mac
Show all formulas Ctrl + ~ Ctrl + ~
Insert an array formula Ctrl + Shift. + Enter ? + Shift + Return
Hide a displayed array formula Ctrl + E ? + E
Show or hide formula help (when entering a formula) Shift + F1 Shift + Fn + F1
Full or compact formula help (when entering a formula) F1 Fn + F1
Absolute or relative references (when entering a formula) F4 Fn + F4
Toggle formula result previews (when entering a formula) F9 Fn + F9
Modify the size of the formula bar (increase or decrease) Ctrl + up arrow or Ctrl + down arrow Ctrl + Option + up arrow or Ctrl + Option + down arrow

Screen Reader Help Google Sheets Shortcuts

  Key combinations for Windows Key combinations for Mac
Enable screen reader support Ctrl + Alt + Z ? + Option + Z
Read a column Ctrl + Alt + Shift + C ? + Option + Shift + C
Read a row Ctrl + Alt + Shift + R ? + Option + Shift + R

Access the list of keyboard shortcuts directly in Google Sheets

With the key combination [Ctrl] + [/] (division symbol on the numeric keyboard) on Windows or [?] + [/] On Mac you can see a list of all the keyboard shortcuts available in Google Sheets:

image
In the menu bar, click? Help? and then in? Shortcuts? or use the keyboard shortcut [Ctrl] + [/] (Windows) or [?] + [/] (Mac) to access the key combination menu.
advice

The keyboard shortcuts or shortcuts exist in other Office programs and on any operating system. In the Digital Guide you can consult articles about shortcuts in Google Docs, shortcuts in Mac, shortcuts in Word, shortcuts in Photoshop, shortcuts in PowerPoint, shortcuts in Windows and shortcuts in Excel..

Use supported shortcuts in Google Sheets

At the bottom of the list of Google Sheets keybindings is there a switch for? Enable supported spreadsheet keybindings ?. If you activate this switch, you can use the familiar keyboard shortcuts from Excel and other spreadsheet programs in Google Sheets.

image
The supported key combinations allow you to use keyboard shortcuts from other spreadsheet programs.

If you click the link on the right? See supported key combinations ?, a list with Google Sheets shortcuts opens.

...