Google Sheets Keyboard Shortcuts for PC, MAC, Chrome OS | Tutorial on Keyboard Shortcuts for Google Sheets

With the help of Keyboard Shortcuts in Google Sheets, we can navigate, format, and use several functions with a few key buttons. Also using Keyboard can save us a lot of time by performing n number of operations. Save your time by learning these Google Sheets shortcut keys and we are sure you will see the difference in your productivity.

Also Read: Start thread by member function with arguments

In this article, let’s go through the list of keyboard shortcuts for PC, MAC, and Chrome OS with important Google Sheet tips. Read on to find more about the Shortcut Keys in Google Sheets based on different categories.

Table of Contents

How to Check List of Keyboard Shortcuts in Google Sheets?

When it comes to keyboard shortcuts, we are familiar with few shortcuts such as Cut, Copy, Paste. However, it’s hard to remember the Keyboard shortcuts such as navigating a menu, usage of formulas, and so on. Thus to ease this process, the Google Spreadsheet shows up the list of formulas that are available on the Sheets and what functions need to be performed to enable the operations. The steps to view the list of Google Keyboard shortcuts for Spreadsheet are given below:

  • Step 1: Open the Google Spreadsheet.
  • Step 2: Now click on the “Help” tab from the menubar.
  • Step 3: Select Keyboard Shortcuts from the dropdown menu.

keyboard shortcuts in google sheets Now the spreadsheet shows the list of Google Sheets Custom Keyboard Shortcuts on the screen. keyboard shortcuts in google sheets Now let’s skim through the list of Google Sheets Keyboard Shortcuts for PC, MAC, and Chrome OS.

Keyboard Shortcuts for Common Actions in Google Sheets

The common action shortcuts in Google Sheets for PC, MAC OS and Chroms OS are tabulated below:

Common Actions Google Sheets Shortcuts for PC Google Sheets Shortcuts for MAC OS Chrome OS Keyboard Shortcuts Google Sheets
Select column Ctrl + Space Ctrl + Space Ctrl + Space
Select row Shift + Space Shift + Space Shift + Space
Select all Ctrl + a Ctrl + Shift + Space ⌘ + a⌘ + Shift + Space Ctrl + a
Undo Ctrl + z ⌘ + z Ctrl + z
Redo Ctrl + y Ctrl + Shift + z F4 ⌘ + y ⌘ + Shift + z Fn + F4 Ctrl + y Ctrl + Shift + z
Find Ctrl + f ⌘ + f Ctrl + f
Find and replace Ctrl + h ⌘ + Shift + h Ctrl + h
Fill range Ctrl + Enter ⌘ + Enter Ctrl + Enter
Fill down Ctrl + d ⌘ + d Ctrl + d
Fill right Ctrl + r ⌘ + r Ctrl + r
Save (every change is saved automatically in Drive) Ctrl + s ⌘ + s Ctrl + s
Open Ctrl + o ⌘ + o Ctrl + o
Print Ctrl + p ⌘ + p Ctrl + p
Copy Ctrl + c ⌘ + c Ctrl + c
Cut Ctrl + x ⌘ + x Ctrl + x
Paste Ctrl + v ⌘ + v Ctrl + v
Paste values only Ctrl + Shift + v ⌘ + Shift + v Ctrl + Shift + v
Show common keyboard shortcuts Ctrl + / ⌘ + / Ctrl + /
Insert new sheet Shift + F11 Shift + Fn + F11
Compact controls Ctrl + Shift + f Ctrl + Shift + f Ctrl + Shift + f
Input tools on/off (available in spreadsheets in non-Latin languages) Ctrl + Shift + k ⌘ + Shift + k Ctrl + Shift + k
Select input tools Ctrl + Alt + Shift + k ⌘ + Option + Shift + k Ctrl + Alt + Shift + k
Search the menus Alt + / Option + / Alt + /

Format Cells Keyboard Shortcuts in Google Sheets

The list of keyboard shortcuts with the help of which we can format the cells in PC, MAC or Chrome OS are explained below:

Format Cells Google Sheets Shortcuts for PC Google Sheets Shortcuts for MAC OS Chrome OS Keyboard Shortcuts Google Sheets
Bold Ctrl + b ⌘ + b Ctrl + b
Underline Ctrl + u ⌘ + u Ctrl + u
Italic Ctrl + i ⌘ + i Ctrl + i
Strikethrough Alt + Shift + 5 Option + Shift + 5 Alt + Shift + 5
Center align Ctrl + Shift + e ⌘ + Shift + e Ctrl + Shift + e
Left align Ctrl + Shift + l ⌘ + Shift + l Ctrl + Shift + l
Right align Ctrl + Shift + r ⌘ + Shift + r Ctrl + Shift + r
Apply top border Alt + Shift + 1 Option + Shift + 1 Alt + Shift + 1
Apply right border Alt + Shift + 2 Option + Shift + 2 Alt + Shift + 2
Apply bottom border Alt + Shift + 3 Option + Shift + 3 Alt + Shift + 3
Apply left border Alt + Shift + 4 Option + Shift + 4 Alt + Shift + 4
Remove borders Alt + Shift + 6 Option + Shift + 6 Alt + Shift + 6
Apply outer border Alt + Shift + 7 Ctrl + Shift + 7 Option + Shift + 7 ⌘ + Shift + 7 Alt + Shift + 7 Ctrl + Shift + 7
Insert link Ctrl + k ⌘ + k Ctrl + k
Insert time Ctrl + Shift + ; ⌘ + Shift + ; Ctrl + Shift + ;
Insert date Ctrl + ; ⌘ + ; Ctrl + ;
Insert date and time Ctrl + Alt + Shift + ; ⌘ + Option + Shift + ; Ctrl + Alt + Shift + ;
Format as decimal Ctrl + Shift + 1 Ctrl + Shift + 1 Ctrl + Shift + 1
Format as time Ctrl + Shift + 2 Ctrl + Shift + 2 Ctrl + Shift + 2
Format as date Ctrl + Shift + 3 Ctrl + Shift + 3 Ctrl + Shift + 3
Format as currency Ctrl + Shift + 4 Ctrl + Shift + 4 Ctrl + Shift + 4
Format as percentage Ctrl + Shift + 5 Ctrl + Shift + 5 Ctrl + Shift + 5
Format as exponent Ctrl + Shift + 6 Ctrl + Shift + 6 Ctrl + Shift + 6
Clear formatting Ctrl + \ ⌘ + \ Ctrl + \

Keyboard Shortcuts for Rows/Columns

Google Sheet Keyboard Shortcuts For Menu Google Sheets Shortcuts for PC/Chrome OS Google Sheets Shortcuts for MAC OS
Insert rows above Ctrl + Alt + Shift + = Ctrl + Alt + = (with rows selected) in 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 in 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 columns selected) in Google Chrome: Alt + i, then c other browsers: Alt + Shift + i, then c ⌘ + Option + = (with columns selected) Ctrl + Option + i, then c
Insert columns to the right in 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) in 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) in 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
Unhide row Ctrl + Shift + 9 ⌘ + Shift + 9
Hide column Ctrl + Alt + 0 ⌘ + Option + 0
Unhide 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
Expand grouped rows or columns Alt + Shift + Down Arrow Option + Shift + Down Arrow
Collapse grouped rows or columns Alt + Shift + Up Arrow Option + Shift + Up Arrow

Navigate Spreadsheet using Google Sheets Keyboard Shortcuts

We can navigate spreadsheets by using the following keys on the keyboard:

Navigate Spreadsheet Google Sheets Shortcuts for PC Google Sheets Shortcuts for MAC OS
Move to begin of row Home Fn + Left Arrow
Move to begin of sheet Ctrl + Home ⌘ + Fn + Left Arrow
Move to end of row End Fn + Right Arrow
Move to end of the sheet Ctrl + End ⌘ + Fn + Right Arrow
Scroll to the active cell Ctrl + Backspace ⌘ + Backspace
Move to the next sheet Alt + Down Arrow Option + Down Arrow
Move to the previous sheet Alt + Up Arrow Option + Up Arrow
Display list of sheets Alt + Shift + k Option + Shift + k
Open hyperlink Alt + Enter Option + Enter
Open Explore Alt + Shift + x Option + Shift + x
Go to the side panel Ctrl + Alt + . Ctrl + Alt + , ⌘ + Option + . ⌘ + Option + ,
Move focus out of the spreadsheet Ctrl + Alt + Shift + m Ctrl + ⌘ + Shift + m
Move to quicksum (when a range of cells is selected) Alt + Shift + q Option + Shift + q
Move focus to popup (for links, bookmarks, and images) holding Ctrl + Alt, press e then p holding Ctrl + ⌘, press e then p
Open drop-down menu on filtered cell Ctrl + Alt + r Ctrl + ⌘ + r
Open revision history Ctrl + Alt + Shift + h ⌘ + Option + Shift + h
Close drawing editor Shift + Esc ⌘ + Esc Shift + Esc

Chrome OS Shortcuts to Navigate Menu

Move to begin of row Search + Left Arrow
Move to end of row Search + Right Arrow
Move to the first cell in row with data Ctrl + Left Arrow
Move to top left of the sheet Ctrl + Search + Left Arrow
Move to the last cell in a row with data Ctrl + Right Arrow
Move to the bottom right of the sheet Ctrl + Search + Right Arrow
Scroll to the active cell Ctrl + Backspace
Move to begin of sheet Ctrl + Search + Left Arrow
Move to end of the sheet Ctrl + Search + Right Arrow
Move to the next sheet Ctrl + Shift + Search + Down Arrow
Move to the previous sheet Ctrl + Shift + Search + Up Arrow
Display list of sheets Alt + Shift + k
Open hyperlink Alt + Enter
Open Explore Alt + Shift + x
Go to the side panel Alt + Shift + . Alt + Shift + ,
Move focus out of the spreadsheet Ctrl + Alt + Shift + m
Move to quicksum (when a range of cells is selected) Alt + Shift + q
Move focus to popup (for links, bookmarks, and images) holding Ctrl + Alt, press e then p
To open the drop-down menu on filtered cell Ctrl + Alt + r
Open revision history Ctrl + Alt + Shift + h
Close drawing editor Ctrl + Esc Shift + Esc

Edits Notes and Comments in Google Sheets using Keyboard Shortcuts

Edit notes and comments Google Sheets Shortcuts for PC Google Sheets Shortcuts for MAC OS Chrome OS Keyboard Shortcuts Google Sheets
Insert/edit note Shift + F2 Shift + F2 Shift + Search + 2
Insert/edit comment Ctrl + Alt + m ⌘ + Option + m Ctrl + Alt + m
Open comment discussion thread Ctrl + Alt + Shift + a ⌘ + Option + Shift + a Ctrl + Alt + Shift + a
Enter current comment holding Ctrl + Alt, press e then c holding Ctrl + ⌘, press e then c holding Ctrl + Alt, press e then c
Move to the next comment holding Ctrl + Alt, press n then c holding Ctrl + ⌘, press n then c holding Ctrl + Alt, press n then c
Move to previous comment holding Ctrl + Alt, press p then c holding Ctrl + ⌘, press p then c holding Ctrl + Alt, press p then c

To Use Keyboard Shortcuts only on Selected Comments

Use Keyboard Shortcuts on Selected Comments Google Sheets Shortcuts for PC Google Sheets Shortcuts for MAC OS Chrome OS Keyboard Shortcuts Google Sheets
Reply to the current comment R R R
Move to the next comment J J J
Move to previous comment K K K
Resolve current comment E E E
Exit current comment U U U

Google Sheet Keyboard Shortcuts to Open a Menu

Google Sheet Keyboard Shortcuts For Menu Google Sheets Shortcuts for PC/Chrome OS Google Sheets Shortcuts for MAC OS
File menu in Google Chrome: Alt + f other browsers: Alt + Shift + f Ctrl + Option + f
Edit menu in Google Chrome: Alt + e other browsers: Alt + Shift + e Ctrl + Option + e
View menu in Google Chrome: Alt + v other browsers: Alt + Shift + v Ctrl + Option + v
Insert menu in Google Chrome: Alt + i other browsers: Alt + Shift + i Ctrl + Option + i
Format menu in Google Chrome: Alt + o other browsers: Alt + Shift + o Ctrl + Option + o
Data menu in Google Chrome: Alt + d other browsers: Alt + Shift + d Ctrl + Option + d
Tools menu in Google Chrome: Alt + t other browsers: Alt + Shift + t Ctrl + Option + t
Open insert menu Ctrl + Alt + Shift + = Ctrl + Alt + = (with cells selected) ⌘ + Option + = (with cells selected)
Open delete menu Ctrl + Alt + – (with cells selected) ⌘ + Option + – (with cells selected)
Form menu (present when the spreadsheet is connected to a form) in Google Chrome: Alt + m other browsers: Alt + Shift + m Ctrl + Option + m
Add-ons menu in Google Chrome: Alt + n other browsers: Alt + Shift + n Ctrl + Option + n
Help menu in Google Chrome: Alt + h other browsers: Alt + Shift + h Ctrl + Option + h
Accessibility menu (present when screen reader support is enabled) in Google Chrome: Alt + a other browsers: Alt + Shift + a Ctrl + Option + a
Sheet menu (copy, delete, and other sheet actions) Alt + Shift + s Option + Shift + s
Context menu Ctrl + Shift + \ Shift + F10 ⌘ + Shift + \ Shift + F10

Google Sheet Keyboard Shortcuts for Formulas and Screen Readers

Google Sheet Keyboard Shortcuts for Formulas and Screen Readers Google Sheets Shortcuts for PC/Chrome OS Google Sheets Shortcuts for MAC OS
Show all formulas Ctrl + ~ Ctrl + ~
Insert array formula Ctrl + Shift + Enter ⌘ + Shift + Enter
Collapse an expanded array formula Ctrl + e ⌘ + e
Show/hide formula help (when entering a formula) Shift + F1 Shift + Fn + F1
Full/compact formula help (when entering a formula) F1 Fn + F1
Absolute/relative references (when entering a formula) F4 Fn + F4
Toggle formula result previews (when entering a formula) F9 Fn + F9
Resize formula bar (move up or down) Ctrl + Up / Ctrl + Down Ctrl + Option + Up and Ctrl + Option + Down
Turn on screen reader support Ctrl + Alt + z ⌘ + Option + z
Enable braille support Ctrl + Alt + h ⌘ + Option + h
Read column Ctrl + Alt + Shift + c ⌘ + Option + Shift + c
Read row Ctrl + Alt + Shift + r ⌘ + Option + Shift + r

Conclusion

We wish the information prevailing on our page with regards to Google Sheets Keyboard Shortcuts has enlightened you. If you need further Excel Keyboard Shortcuts on various similar platforms you can visit our site.

Leave a Comment