[115+] Google Sheets Shortcuts For Windows And MAC

Google sheets Shortcuts

Google Sheets is one of the best alternatives that is used against Microsoft Excel. Earlier we have discussed about the Excel Shortcuts that may help you to work professionally.

In this article, we have managed to provide you the list of Google Sheets Shortcuts For Windows and MAC. Also, the Google Sheets Shortcuts are almost the same, so it will be easy for the ones who know Excel Shortcut Keys. 

Although, you may get all the shortcut keys in the Google sheets itself.

  • Click Here to Open Google Sheets
  • To open a list of keyboard shortcuts, press Ctrl + / (Windows and Chrome OS), Cmd + / (macOS)
  • To search the menus, press Alt + / (Windows, Chrome OS) or Option + / (Mac).

If you want to see the complete list, check out the Google support page.

Featured Posts –

Shortcut Keys For Command Actions 

Action Windows ShortcutsMAC Shortcuts
Select columnCtrl + SpaceCtrl + Space
Select rowShift + SpaceShift + Space
Select allCtrl + a
Ctrl + Shift + Space
⌘ + a
⌘ + Shift + Space
UndoCtrl + z⌘ + z
RedoCtrl + y
Ctrl + Shift + z
F4
⌘ + y
⌘ + Shift + z
Fn + F4
FindCtrl + f⌘ + f
Find and replaceCtrl + h⌘ + Shift + h
Fill rangeCtrl + Enter⌘ + Enter
Fill downCtrl + d⌘ + d
Fill rightCtrl + r⌘ + r
SaveCtrl + s⌘ + s
OpenCtrl + o⌘ + o
PrintCtrl + p⌘ + p
CopyCtrl + c⌘ + c
CutCtrl + x⌘ + x
Paste Ctrl + v⌘ + v
Paste values onlyCtrl + Shift + v⌘ + Shift + v
Show common keyboard shortcutsCtrl + /⌘ + /
Insert new sheetShift + F11Shift + Fn + F11
Compact controlsCtrl + Shift + fCtrl + Shift + f
Input tools on/offCtrl + Shift + k⌘ + Shift + k
Select input toolsCtrl + Alt + Shift + k⌘ + Option + Shift + k
Search the menusAlt + /Option + /

Shortcut Keys Used for Format Cells

Action Windows ShortcutsMAC Shortcuts
BoldCtrl + b⌘ + b
UnderlineCtrl + u⌘ + u
ItalicCtrl + i⌘ + i
StrikethroughAlt + Shift + 5Option + Shift + 5
Center alignCtrl + Shift + e⌘ + Shift + e
Left alignCtrl + Shift + l⌘ + Shift + l
Right alignCtrl + Shift + r⌘ + Shift + r
Apply top borderAlt + Shift + 1Option + Shift + 1
Apply right borderAlt + Shift + 2Option + Shift + 2
Apply bottom borderAlt + Shift + 3Option + Shift + 3
Apply left borderAlt + Shift + 4Option + Shift + 4
Remove bordersAlt + Shift + 6Option + Shift + 6
Apply outer border

Alt + Shift + 7
Ctrl + Shift + 7

Option + Shift + 7
⌘ + Shift + 7

Insert linkCtrl + k⌘ + k
Insert timeCtrl + Shift + ;⌘ + Shift + ;
Insert dateCtrl + ;⌘ + ;
Insert date and timeCtrl + Alt + Shift + ;⌘ + Option + Shift + ;
Format as decimalCtrl + Alt + Shift + ;Ctrl + Shift + 1
Format as timeCtrl + Shift + 2Ctrl + Shift + 2
Format as dateCtrl + Shift + 3Ctrl + Shift + 3
Format as currencyCtrl + Shift + 4Ctrl + Shift + 4
Format as percentageCtrl + Shift + 5Ctrl + Shift + 5
Format as exponentCtrl + Shift + 6Ctrl + Shift + 6
Clear formattingCtrl + \⌘ + \

Shortcuts to Navigate Spreadsheet

Action Windows ShortcutsMAC Shortcuts
Move to beginning of rowHomeFn + Left Arrow
Move to beginning of sheetCtrl + Home⌘ + Fn + Left Arrow
Move to end of rowEndFn + Right Arrow
Move to end of sheetCtrl + End⌘ + Fn + Right Arrow
Scroll to active cellCtrl + Backspace⌘ + Backspace
Move to next sheetAlt + Down ArrowOption + Down Arrow
Move to previous sheetAlt + Up ArrowOption + Up Arrow
Display list of sheetsAlt + Shift + kOption + Shift + k
Open hyperlinkAlt + EnterOption + Enter
Open ExploreAlt + Shift + xOption + Shift + x
Go to side panelCtrl + Alt + .
Ctrl + Alt + ,
⌘ + Option + .
⌘ + Option + ,
Move focus out of spreadsheetCtrl + Alt + Shift + mCtrl + ⌘ + Shift + m
Move to quicksumAlt + Shift + qOption + Shift + q
Move focus to popupholding Ctrl + Alt, press e then pholding Ctrl + ⌘, press e then p
Open drop-down menu on filtered cellCtrl + Alt + rCtrl + ⌘ + r
Open revision historyCtrl + Alt + Shift + h⌘ + Option + Shift + h
Open chat inside the spreadsheetShift + EscShift + Esc
Close drawing editorShift + Esc⌘ + Esc
Shift + Esc

Shortcut Keys For Editing Notes and Comments

ActionsWindows ShortcutsMAC Shortcuts
Insert/edit noteShift + F2Shift + F2
Insert/edit commentCtrl + Alt + m⌘ + Option + m
Open comment discussion threadCtrl + Alt + Shift + a⌘ + Option + Shift + a
Enter current commentholding Ctrl + Alt, press e then cholding Ctrl + ⌘, press e then c
Move to next commentholding Ctrl + Alt, press n then cholding Ctrl + ⌘, press n then c
Move to previous commentholding Ctrl + Alt, press p then cholding Ctrl + ⌘, press p then c

Shortcut Keys For Opening Menu

ActionsWindows ShortcutsMAC Shortcuts
File menuin Google Chrome: Alt + f
other browsers: Alt + Shift + f
Ctrl + Option + f
Edit menuin Google Chrome: Alt + e
other browsers: Alt + Shift + e
Ctrl + Option + e
View menun Google Chrome: Alt + v
other browsers: Alt + Shift + v
Ctrl + Option + v
Insert menuin Google Chrome: Alt + i
other browsers: Alt + Shift + i
Ctrl + Option + i
Format menuin Google Chrome: Alt + o
other browsers: Alt + Shift + o
Ctrl + Option + o
Data menuin Google Chrome: Alt + d
other browsers: Alt + Shift + d
Ctrl + Option + d
Tools menuin Google Chrome: Alt + t
other browsers: Alt + Shift + t
Ctrl + Option + t
Open insert menuCtrl + Alt + Shift + = 
Ctrl + Alt + = 

(with cells selected)
⌘ + Option + = (with cells selected)
Open delete menuCtrl + Alt + – (with cells selected)⌘ + Option + – (with cells selected)
Form menuin Google Chrome: Alt + m
other browsers: Alt + Shift + m
Ctrl + Option + m
Add-ons menuin Google Chrome: Alt + n
other browsers: Alt + Shift + n
Ctrl + Option + n
Help menuin Google Chrome: Alt + h
other browsers: Alt + Shift + h
Ctrl + Option + h
Accessibility menuin Google Chrome: Alt + a
other browsers: Alt + Shift + a
Ctrl + Option + a
Sheet menuAlt + Shift + sOption + Shift + s
Context menuCtrl + Shift + \⌘ + Shift + \

Shortcuts For Changing Rows and Columns

ActionsWindows ShortcutsMAC Shortcuts
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 belowin 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 rightin 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 rowCtrl + Alt + 9⌘ + Option + 9
Unhide rowCtrl + Shift + 9⌘ + Shift + 9
Hide columnCtrl + Alt + 0⌘ + Option + 0
Unhide columnCtrl + Shift + 0⌘ + Shift + 0
Group rows or columnsAlt + Shift + Right ArrowOption + Shift + Right Arrow
Ungroup rows or columnsAlt + Shift + Left ArrowOption + Shift + Left Arrow
Expand grouped rows or columnsAlt + Shift + Down ArrowOption + Shift + Down Arrow 
Collapse grouped rows or columnsAlt + Shift + Up ArrowOption + Shift + Up Arrow 

Shortcut Keys For Using Formulas

ActionsWindows ShortcutsMAC Shortcuts
Show all formulasCtrl + ~Ctrl + ~
Insert array formulaCtrl + Shift + Enter⌘ + Shift + Enter
Collapse an expanded array formulaCtrl + e⌘ + e
Show/hide formula helpShift + F1Shift + Fn + F1
Full/compact formula helpF1Fn + F1
Absolute/relative referencesF4Fn + F4
Toggle formula result previewsF9Fn + F9
Resize formula barCtrl + Up / Ctrl + DownCtrl + Option + Up and Ctrl + Option + Down

So, this is the list of Google Sheet Shortcuts for Windows and MAC users. Almost Every Shortcut Keys and Function Keys are covered in the above Shortcuts Table. Try to Practise these Google Sheets Shortcuts while doing your work. In this manner, you will easily remember the shortcuts for Google Sheets.

Download Google Sheets Keyboard Shortcut keys in PDF

Google Sheets Shortcut keys.pdf

Download Google Sheets Keyboard Shortcut keys in Excel

Google Sheets Shortcut keys.xlsx

You May Also Like

Hope you have liked our blog on Google Sheets Shortcuts. Suggestions are always welcomed for the blog you looking forward to hearing from us. Connect with us and Take your Office Productivity to Next Level.

Pin It on Pinterest

Share This

Share This

Share this post with your friends!

Share This

Share this post with your friends!