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 keys | For Pc | For Mac |
---|---|---|
Select all | Ctrl + a | ⌘ + a |
Underline | Ctrl + u | ⌘ + u |
Undo | Ctrl + z | ⌘ + z |
Bold | Ctrl + b | ⌘ + b |
Copy | Ctrl + c | ⌘ + c |
Cut | Ctrl + x | ⌘ + x |
Fill down | Ctrl + d | ⌘ + d |
Fill range | Ctrl + Enter | ⌘ + Enter |
Fill right | Ctrl + r | ⌘ + r |
Find | Ctrl + f | ⌘ + f |
Find and replace | Ctrl + h | ⌘ + Shift + h |
Insert link | Ctrl + k | ⌘ + k |
Italic | Ctrl + i | ⌘ + i |
Open | Ctrl + o | ⌘ + o |
Paste | Ctrl + v | ⌘ + v |
Ctrl + p | ⌘ + p | |
Redo | Ctrl + y | ⌘ + y |
Save | Ctrl + s | ⌘ + s |
Insert new sheet | Shift + F11 | Shift + Fn + F11 |
Insert time | Ctrl + Shift + ; | ⌘ + Shift + ; |
Left align | Ctrl + Shift + l | ⌘ + Shift + l |
Paste values only | Ctrl + Shift + v | ⌘ + Shift + v |
Remove borders | Alt + Shift + 6 | Option + Shift + 6 |
Right align | Ctrl + Shift + r | ⌘ + Shift + r |
Search the menus | Alt + / | Option + / |
Select column | Ctrl + Space | Ctrl + Space |
Select input tools | Ctrl + Alt + Shift + k | ⌘ + Option + Shift + k |
Select row | Shift + Space | Shift + Space |
Show common keyboard shortcuts | Ctrl + / | ⌘ + / |
Strikethrough | Alt + Shift + 5 | Option + Shift + 5 |
Apply bottom border | Alt + Shift + 3 | Option + Shift + 3 |
Apply left border | Alt + Shift + 4 | Option + Shift + 4 |
Apply outer border | Alt + Shift + 7 | Option + Shift + 7 |
Apply right border | Alt + Shift + 2 | Option + Shift + 2 |
Apply top border | Alt + Shift + 1 | Option + Shift + 1 |
Format as currency | Ctrl + Shift + 4 | Ctrl + Shift + 4 |
Format as date | Ctrl + Shift + 3 | Ctrl + Shift + 3 |
Format as decimal | Ctrl + Shift + 1 | Ctrl + Shift + 1 |
Format as exponent | Ctrl + Shift + 6 | Ctrl + Shift + 6 |
Format as percentage | Ctrl + Shift + 5 | Ctrl + Shift + 5 |
Format as time | Ctrl + Shift + 2 | Ctrl + Shift + 2 |
Input tools on/off | Ctrl + Shift + k | ⌘ + Shift + k |
Insert date | Ctrl + ; | ⌘ + ; |
Insert date and time | Ctrl + 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.
Function | For Pc | For Mac |
---|---|---|
Repeat the Last Action | F4 | Not available on Mac |
Insert Row Above | ALT + I + R | Ctrl + Option + I + R |
Insert Row Below | ALT + I + W | Ctrl + Option + I + W |
Insert Column above | ALT + I + C | Ctrl + Option + I + C |
Insert Column below | ALT + I + G | Ctrl + Option + I + G |
Delete Current Row | ALT + E + D | Ctrl + Option + E + D |
Delete Current Column | ALT + E + E | Ctrl + Option + E + E |
Select Whole Row | Shift + Spacebar | Shift + Spacebar |
Select Whole Column | Control + Spacebar | Control + Spacebar |
Paste Values Only | Control + Shift + V | Command + Shift + V |
Paste Format Only | Control + ALT + V | Command + ALT + V |
Find Values | Control + F | Command + F |
Find and Replace | Control + H | Command + Shift + F |
Add new sheet | Shift + F11 | Not available on Mac |
Center Align | Ctrl + Shift + E | Command + Shift + E |
Left Align | Ctrl + Shift + L | Command + Shift + L |
Right Align | Ctrl + Shift + R | Command + Shift + R |
Insert Current Time | Ctrl + Shift + ; | Command + Shift + ; |
Insert Current Date | Ctrl + ; | Command + ; |
Clear all formatting | Ctrl + \ | Command + \ |
Move to the Next sheet | Ctrl + Shift + Page Down | Command + Shift + Fn + Down arrow |
Move to the previous sheet | Ctrl + Shift + Page Up | Command + Shift + Fn + Up arrow |
Display all sheets | Alt + Shift + K | Option + Shift + K |
Open Hyperlink | ALT + Enter | Option + Enter |
Insert Note | Shift + F2 | Shift + F2 |
Insert /Edit comment | Control + ALT + M | Command + Option + M |
Show All Formulas | Control ~ | Control ~ |
Fill Down | Control + D | Command + D |
Fill Right | Control + R | Command + 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 shortcuts | For Pc | For Mac |
---|---|---|
Insert rows above | Alt + I + R | Ctrl + Option + i, then r |
Insert rows below | Alt + I + W | Ctrl + Option + i, then b |
Insert columns to the left | Alt + I + C | Ctrl + Option + i, then c |
Insert columns to the right | Alt + I + O | Ctrl + Option + i, then o |
Delete rows | Ctrl + Alt + – (with rows selected) | ⌘ + Option + – |
Delete the columns | Ctrl + Alt + – (with columns selected) | ⌘ + Option + – |
Hide the row | Ctrl + Alt + 9 | ⌘ + Option + 9 |
Unhide the 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 |
Turn on screen reader support | Ctrl + Alt + z | ⌘ + Option + z |
Read column | Ctrl + Alt + Shift + c | ⌘ + Option + Shift + c |
Read row | Ctrl + 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 shortcut | For Pc | For Mac |
---|---|---|
Move to the beginning of row | Home | Fn + Left Arrow |
Move to the beginning of the sheet | Ctrl + Home | ⌘ + Fn + Left Arrow |
Move to end of the 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 + . | ⌘ + Option + . |
Move focus out of spreadsheet | Ctrl + Alt + Shift + m | Ctrl + ⌘ + Shift + m |
Move to quicksum | Alt + Shift + q | Option + Shift + q |
Move focus to popup | 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 |
Open chat inside the spreadsheet | Shift + Esc | Shift + Esc |
Close drawing editor | Shift + 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.