Google Sheets Keyboard shortcuts for window and mac Pdf List

some time ago we all depends on Microsoft excel for spreadsheet tasks. now, Google Sheets become one of the best online worksheet tools. and it becomes easier for you, so, in those posts, we bought All Keyboard shortcuts for Google Sheets pdf.

All Basic Google-Sheet Shortcuts Keys for mac pc

Google Sheets is an Online worksheet tools software that introduces by google. it is similar to Microsoft Excel. Google Spreadsheet has many functions and formulas just like Microsoft Excel. Therefore, dealing with all these functions with a mouse is quite a difficult task.

That’s why Google Sheet shortcuts come to make the work of the worksheet easier. Below are the various shortcuts for Google Sheets that will help you work with Google Sheets effectively. You can download these Commonly Used Google Sheets Shortcuts key for pc or mac os PDFs below.

Shortcut keysFor PcFor Mac
Select allCtrl + a⌘ + a
UnderlineCtrl + u⌘ + u
UndoCtrl + z⌘ + z
BoldCtrl + b⌘ + b
CopyCtrl + c⌘ + c
CutCtrl + x⌘ + x
Fill downCtrl + d⌘ + d
Fill rangeCtrl + Enter⌘ + Enter
Fill rightCtrl + r⌘ + r
FindCtrl + f⌘ + f
Find and replaceCtrl + h⌘ + Shift + h
Insert linkCtrl + k⌘ + k
ItalicCtrl + i⌘ + i
OpenCtrl + o⌘ + o
PasteCtrl + v⌘ + v
PrintCtrl + p⌘ + p
RedoCtrl + y⌘ + y
SaveCtrl + s⌘ + s
Insert new sheetShift + F11Shift + Fn + F11
Insert timeCtrl + Shift + ;⌘ + Shift + ;
Left alignCtrl + Shift + l⌘ + Shift + l
Paste values onlyCtrl + Shift + v⌘ + Shift + v
Remove bordersAlt + Shift + 6Option + Shift + 6
Right alignCtrl + Shift + r⌘ + Shift + r
Search the menusAlt + /Option + /
Select columnCtrl + SpaceCtrl + Space
Select input toolsCtrl + Alt + Shift + k⌘ + Option + Shift + k
Select rowShift + SpaceShift + Space
Show common keyboard shortcutsCtrl + /⌘ + /
StrikethroughAlt + Shift + 5Option + Shift + 5
Apply bottom borderAlt + Shift + 3Option + Shift + 3
Apply left borderAlt + Shift + 4Option + Shift + 4
Apply outer borderAlt + Shift + 7Option + Shift + 7
Apply right borderAlt + Shift + 2Option + Shift + 2
Apply top borderAlt + Shift + 1Option + Shift + 1
Format as currencyCtrl + Shift + 4Ctrl + Shift + 4
Format as dateCtrl + Shift + 3Ctrl + Shift + 3
Format as decimalCtrl + Shift + 1Ctrl + Shift + 1
Format as exponentCtrl + Shift + 6Ctrl + Shift + 6
Format as percentageCtrl + Shift + 5Ctrl + Shift + 5
Format as timeCtrl + Shift + 2Ctrl + Shift + 2
Input tools on/offCtrl + Shift + k⌘ + Shift + k
Insert dateCtrl + ;⌘ + ;
Insert date and timeCtrl + Alt + Shift + ;⌘ + Option + Shift + ;

Most Importaint 20 Google Sheets Keyboard Shortcuts

Here are 20+ Google Sheets Formula-related Keyboard Shortcuts keys that you must know to save your time.

FunctionFor PcFor Mac
Repeat the Last ActionF4Not available on Mac
Insert Row AboveALT + I + RCtrl + Option + I + R
Insert Row BelowALT + I + WCtrl + Option + I + W
Insert Column aboveALT + I + CCtrl + Option + I + C
Insert Column belowALT + I + GCtrl + Option + I + G
Delete Current RowALT + E + DCtrl + Option + E + D
Delete Current ColumnALT + E + ECtrl + Option + E + E
Select Whole RowShift + SpacebarShift + Spacebar
Select Whole ColumnControl + SpacebarControl + Spacebar
Paste Values OnlyControl + Shift + VCommand + Shift + V
Paste Format OnlyControl + ALT + VCommand + ALT + V
Find ValuesControl + FCommand + F
Find and ReplaceControl + HCommand + Shift + F
Add new sheetShift + F11Not available on Mac
Center AlignCtrl + Shift + ECommand + Shift + E
Left AlignCtrl + Shift + LCommand + Shift + L
Right AlignCtrl + Shift + RCommand + Shift + R
Insert Current TimeCtrl + Shift + ;Command + Shift + ;
Insert Current DateCtrl + ;Command + ;
Clear all formattingCtrl + \Command + \
Move to the Next sheetCtrl + Shift + Page DownCommand + Shift + Fn + Down arrow
Move to the previous sheetCtrl + Shift + Page UpCommand + Shift + Fn + Up arrow
Display all sheetsAlt + Shift + KOption + Shift + K
Open HyperlinkALT + EnterOption + Enter
Insert NoteShift + F2Shift + F2
Insert /Edit commentControl + ALT + MCommand + Option + M
Show All FormulasControl ~Control ~
Fill DownControl + DCommand + D
Fill RightControl + RCommand + R

Rows and columns keyboard shortcuts for Google sheet

in the google sheet Insert, delete, hide to Rows and columns. all these functions with a mouse are quite difficult, so here Google sheet Rows and columns keyboard shortcuts for mac user help to easily explore these functions.

Rows and columns shortcutsFor PcFor Mac
Insert rows aboveAlt + I + RCtrl + Option + i, then r
Insert rows belowAlt + I + WCtrl + Option + i, then b
Insert columns to the leftAlt + I + CCtrl + Option + i, then c
Insert columns to the rightAlt + I + OCtrl + Option + i, then o
Delete rowsCtrl + Alt + – (with rows selected)⌘ + Option + –
Delete the columnsCtrl + Alt + – (with columns selected)⌘ + Option + –
Hide the rowCtrl + Alt + 9⌘ + Option + 9
Unhide the 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
Turn on screen reader supportCtrl + Alt + z⌘ + Option + z
Read columnCtrl + Alt + Shift + c⌘ + Option + Shift + c
Read rowCtrl + Alt + Shift + r⌘ + Option + Shift + r

Rows and columns Navigate in Google Sheets

Move to the beginning of the row, Scroll to the active cell or Move to the next sheet is a boring task. but using some Navigate shortcut key of google sheet would be very simple and easy. so let’s read Rows and columns navigation shortcut for PC and mac

Navigation shortcutFor PcFor Mac
Move to the beginning of rowHomeFn + Left Arrow
Move to the beginning of the sheetCtrl + Home⌘ + Fn + Left Arrow
Move to end of the rowEndFn + Right Arrow
Move to end of the sheetCtrl + End⌘ + Fn + Right Arrow
Scroll to the active cellCtrl + Backspace⌘ + Backspace
Move to the next sheetAlt + Down ArrowOption + Down Arrow
Move to the 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 the side panelCtrl + Alt + .⌘ + 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

Conclusion

we hope, all these google sheet shortcut keys help to save your time. we also cover Google Sheets Keyboard Shortcuts for mac users that are such an awesome thing. if you have any suggestions or queries then plz contact us.

Leave a Comment