It's amazing how many keyboard shortcuts are available to you in Google Sheets. Let's take a few minutes to review the most helpful keyboard shortcuts and talk about how to find other shortcuts that may be helpful for you. Keyboard shortcuts are combinations of two or more keys that you can use to perform a task that would normally require a mouse. Using keyboard shortcuts with Google Sheets can make it easier to work with your spreadsheet data entry and editing, saving you time and effort. You're probably familiar with some of the more common keyboard shortcuts available in word processing programs such as cutting text, Ctrl+X on a PC or Cmd+X on a Mac.
Copying text, CTRL+C on a PC or Cmd+C on a Mac, and Paste, CTRL+V or Cmd+V. These are available in Google Sheets as well. I can select a cell or group of cells, and I can use my keyboard to cut, copy or paste. I'll copy and paste this cell to the next cell. But if you're entering a lot of data, or if you need to format your spreadsheet in a specific way and you want to save time, look to the extensive keyboard shortcuts in Google Sheets to see if there's a shortcut that will help save you time.
I'll just review a few of these shortcuts to show you how they might save you time, and I'll show you using this Solar Panel Chart. If you want to enter today's date, press the Ctrl key on a PC or the Cmd key on Mac and press the semicolon. If you want to enter the current time, hold down the Ctrl on the PC or the Cmd key on a Mac and press the Shift button, then type the semicolon. Here's one for inserting or editing a comment. On the PC, press Ctrl+Alt+M. On a Mac, press Cmd+Alt+M.
Here's another fun one. Did you know you could move to the start of a row just by hitting the Home key? I'll show you here on the second row. I'll press the Home key on my keyboard, and I'll move to the start of the row. I can go to the end of the row by simply hitting the End key on my keyboard. To find the list of shortcuts for you operating system, you can look at the menu and notice what's available to the right of each command. For example, on the File menu, I can see that Open is Ctrl+O.
See your vision history is Ctrl+Alt+Shift+G. And print is Ctrl+P. To find the entire list of shortcuts for your operating system, you can look under the Help menu and select Keyboard Shortcuts. I'm using a PC, so this list shows me all the PC keyboard shortcuts available in Google Sheets. If you're using a Mac, you'll see a list of Mac keyboard shortcuts for Google Sheets here. Let's take a quick look at the types of keyboard shortcuts that Google provides. There are Editing shortcuts like undo, fill and redo. There are Movement shortcuts like moving to the active row or sheet.
There are Menu shortcuts that allow you to open all the menus without clicking a mouse. There are Formatting shortcuts for text, border alignment and data formatting. There are Selection shortcuts for selecting large areas without clicking. If you're using a screen reader program to read text, you can use the Screenreader shortcuts to hear columns and rows read aloud. There are Insertion, File Command and View shortcuts. And you can navigate the window or open help documentation using other keyboard shortcuts here. But remember, there are lot of them available to you when you're doing a repetitive task.
Most likely, there's a keyboard shortcut that will save you a lot of time.
- Navigating Google Sheets
- Creating, naming, and saving spreadsheets
- Importing files
- Converting other file formats such as Microsoft Excel to Google Sheets
- Editing cells
- Inserting, deleting, and moving rows and columns
- Adding hyperlinks and images
- Formatting data
- Using formulas and functions
- Sharing spreadsheets
- Using the Google Sheets mobile app
Skill Level Intermediate
Q: This course was updated on 04/17/2018. What changed?
A: We revised five videos to reflect the latest features and enhancements in Google Sheets.
Q: This course was updated on 10/17/2018. What changed?
A: New videos were added that cover customizing your printed spreadsheet and automating tasks with recorded macros.