All the Best Google Sheets Keyboard Shortcuts
Text Source: howtogeek.com
#SHORTCUTS #KEYBOARD #SHEETS #GOOGLE #BEST #THE #ALL
All the Best Google Sheets Keyboard Shortcuts
No one likes to do things the hard way, which is why we have keyboard shortcuts! We’re going to look at the shortcuts you can use in Google Sheets to save yourself some time.
By no means is this a complete list of all keyboard shortcuts available in Google Sheets. We’ve limited our list to those that are more generally useful. There are plenty more you can explore if you can’t find what you’re looking for in this guide.
To open a list of keyboard shortcuts in Google Sheets, press Ctrl + / (Windows and Chrome OS), Cmd + / (macOS) If you want to see the complete list, check out the Google Sheets support page.
These keyboard shortcuts make it easier to perform common actions, like copying cells or selecting rows or columns:
Ctrl+Alt+Shift+H (Windows/Chrome OS) or Cmd+Option+Shift+H (macOS): Open the spreadsheet’s revision history.
Google Sheets has heaps of shortcuts you can use to format cells. These are the shortcuts you use to do things like italicize or bold text, or format cell data to exponents:
You can move around your spreadsheet quickly without touching your mouse! With these helpful shortcuts, you can zip between rows and columns:
Ctrl+Left/Right Arrow (Windows/Chrome OS) or Ctrl+Option+Left/Right Arrow (macOS): Move to the first or last cell with data in a row.
Ctrl+Up/Down Arrow (Windows/Chrome OS) or Ctrl+Option+Up/Down Arrow (macOS): Move to the first or last cell with data in a column.
Home (Windows), Search+Left Arrow (Chrome OS), or Fn+Left Arrow (macOS): Move to the beginning of a row.
Ctrl+Home (Windows), Ctrl+Search+Left Arrow (Chrome OS), or Cmd+Fn+Left Arrow (macOS): Move to the beginning of the sheet (A1).
Ctrl+End (Windows), Ctrl+Search+Right Arrow (Chrome OS), or Cmd+Fn+Right Arrow (macOS): Move to the end of the sheet.
Alt+Down/Up Arrow (Windows/Chrome OS) or Option+Down/Up Arrow (macOS): If you have more than one sheet in the current file, use this shortcut to move to the next or previous sheet.
Ctrl+Shift+Enter (Windows/Chrome OS) or Cmd+Shift+Enter (macOS): Insert an array formula (when you input a formula, type “=” first).
If you want to duplicate a cell’s data into a selected range, hide or delete columns or rows, follow the shortcuts below.
Because Google likes to make things complicated, there are some browser-specific commands for these keyboard shortcuts if you use Chrome. If you are, just follow the commands, and then add the “Chrome” shortcut to complete the browser-specific commands:
If you use a Mac, follow these shortcuts to add, remove, or change rows and columns in Google Sheets:
You can use the following shortcuts on a PC to access each menu item. Note that most are slightly different in Chrome:
Alt+A (Chrome) or Alt+Shift+A (Other browsers): Access the Accessibility menu (present when screen reader support is enabled).
Shift+Right-click: Show your browser’s context menu (by default, Google Sheets overrides your browser’s context menu with its own).
Cmd+Option+Shift+K: Open the Input Tools menu (available in all documents that contain non-Latin languages).
Shift+Right-click: Show the browser’s context menu (by default, Google Sheets overrides your browser’s context menu with its own).
As of May 2019, Google allows you to use familiar keyboard shortcuts from other well-known spreadsheet programs. You do have to enable this option, but here’s how:
From your Google Sheets spreadsheet, click Help → Keyboard shortcuts. Alternatively, press Ctrl+/ (Windows/Chrome OS) or Cmd+/ (macOS).
That’s all there is to it! All the shortcuts you’ve learned are now available in Google Sheets. To see a complete list, click “View compatible shortcuts” next to the toggle switch.
Hopefully, all these shortcuts will make your work a lot easier! If you didn’t find the one you need, head over to the Google support page for more.