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 –
Summary
Download Google Sheets Shortcuts PDF
Download Google Sheets Shortcuts PDF
List of Google Sheets Shortcuts For Windows and MAC
Shortcut Keys For Command Actions
| Action | Windows Shortcuts | MAC Shortcuts |
| Select column | Ctrl + Space | Ctrl + Space |
| Select row | Shift + Space | Shift + Space |
| Select all | Ctrl + a Ctrl + Shift + Space |
⌘ + a ⌘ + Shift + Space |
| Undo | Ctrl + z | ⌘ + z |
| Redo | Ctrl + y Ctrl + Shift + z F4 |
⌘ + y ⌘ + Shift + z Fn + F4 |
| Find | Ctrl + f | ⌘ + f |
| Find and replace | Ctrl + h | ⌘ + Shift + h |
| Fill range | Ctrl + Enter | ⌘ + Enter |
| Fill down | Ctrl + d | ⌘ + d |
| Fill right | Ctrl + r | ⌘ + r |
| Save | Ctrl + s | ⌘ + s |
| Open | Ctrl + o | ⌘ + o |
| Ctrl + p | ⌘ + p | |
| Copy | Ctrl + c | ⌘ + c |
| Cut | Ctrl + x | ⌘ + x |
| Paste | Ctrl + v | ⌘ + v |
| Paste values only | Ctrl + Shift + v | ⌘ + Shift + v |
| Show common keyboard shortcuts | Ctrl + / | ⌘ + / |
| Insert new sheet | Shift + F11 | Shift + Fn + F11 |
| Compact controls | Ctrl + Shift + f | Ctrl + Shift + f |
| Input tools on/off | Ctrl + Shift + k | ⌘ + Shift + k |
| Select input tools | Ctrl + Alt + Shift + k | ⌘ + Option + Shift + k |
| Search the menus | Alt + / | Option + / |
Shortcut Keys Used for Format Cells
| Action | Windows Shortcuts | MAC Shortcuts |
| Bold | Ctrl + b | ⌘ + b |
| Underline | Ctrl + u | ⌘ + u |
| Italic | Ctrl + i | ⌘ + i |
| Strikethrough | Alt + Shift + 5 | Option + Shift + 5 |
| Center align | Ctrl + Shift + e | ⌘ + Shift + e |
| Left align | Ctrl + Shift + l | ⌘ + Shift + l |
| Right align | Ctrl + Shift + r | ⌘ + Shift + r |
| Apply top border | 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 borders | Alt + Shift + 6 | Option + Shift + 6 |
| Apply outer border |
Alt + Shift + 7 |
Option + Shift + 7 |
| Insert link | Ctrl + k | ⌘ + k |
| Insert time | Ctrl + Shift + ; | ⌘ + Shift + ; |
| Insert date | Ctrl + ; | ⌘ + ; |
| Insert date and time | Ctrl + Alt + Shift + ; | ⌘ + Option + Shift + ; |
| Format as decimal | Ctrl + Alt + Shift + ; | Ctrl + Shift + 1 |
| Format as time | Ctrl + Shift + 2 | Ctrl + Shift + 2 |
| Format as date | Ctrl + Shift + 3 | Ctrl + Shift + 3 |
| Format as currency | Ctrl + Shift + 4 | Ctrl + Shift + 4 |
| Format as percentage | Ctrl + Shift + 5 | Ctrl + Shift + 5 |
| Format as exponent | Ctrl + Shift + 6 | Ctrl + Shift + 6 |
| Clear formatting | Ctrl + | ⌘ + |
Shortcuts to Navigate Spreadsheet
| Action | Windows Shortcuts | MAC Shortcuts |
| Move to beginning of row | Home | Fn + Left Arrow |
| Move to beginning of sheet | Ctrl + Home | ⌘ + Fn + Left Arrow |
| Move to end of row | End | Fn + Right Arrow |
| Move to end of sheet | Ctrl + End | ⌘ + Fn + Right Arrow |
| Scroll to active cell | Ctrl + Backspace | ⌘ + Backspace |
| Move to next sheet | Alt + Down Arrow | Option + Down Arrow |
| Move to 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 side panel | Ctrl + Alt + . Ctrl + Alt + , |
⌘ + Option + . ⌘ + 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 Shift + Esc |
Shortcut Keys For Editing Notes and Comments
| Actions | Windows Shortcuts | MAC Shortcuts |
| Insert/edit note | Shift + F2 | Shift + F2 |
| Insert/edit comment | Ctrl + Alt + m | ⌘ + Option + m |
| Open comment discussion thread | Ctrl + Alt + Shift + a | ⌘ + Option + Shift + a |
| Enter current comment | holding Ctrl + Alt, press e then c | holding Ctrl + ⌘, press e then c |
| Move to next comment | holding Ctrl + Alt, press n then c | holding Ctrl + ⌘, press n then c |
| Move to previous comment | holding Ctrl + Alt, press p then c | holding Ctrl + ⌘, press p then c |
Shortcut Keys For Opening Menu
| Actions | Windows Shortcuts | MAC Shortcuts |
| 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 | n 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 | 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 | in Google Chrome: Alt + a other browsers: Alt + Shift + a |
Ctrl + Option + a |
| Sheet menu | Alt + Shift + s | Option + Shift + s |
| Context menu | Ctrl + Shift + | ⌘ + Shift + |
Shortcuts For Changing Rows and Columns
| Actions | Windows Shortcuts | MAC Shortcuts |
| Insert rows above |
Ctrl + Alt + Shift + = in Google Chrome: Alt + 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 + = in Google Chrome: Alt + 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 |
⌘ + Option + – (with rows selected) Ctrl + Option + e, then d |
| Delete columns |
Ctrl + Alt + – (with columns selected) in Google Chrome: Alt + 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 |
Shortcut Keys For Using Formulas
| Actions | Windows Shortcuts | MAC Shortcuts |
| 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 | Shift + F1 | Shift + Fn + F1 |
| Full/compact formula help | F1 | Fn + F1 |
| Absolute/relative references | F4 | Fn + F4 |
| Toggle formula result previews | F9 | Fn + F9 |
| Resize formula bar | Ctrl + Up / Ctrl + Down | Ctrl + 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
- Most Used Keyboard Shortcuts for MS Word
- List of All Windows Keyboard Shortcuts
- Top 20 most used Gmail Keyboard Shortcuts
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.
