Hello again. In this video, we're going to discuss some basic keyboard shortcuts. You'll learn how to navigate with the keyboard arrows, use the find replace feature to locate important data instantly, and use the undo feature. Now that we've learned how to navigate our spreadsheet, let's learn some shortcuts that'll help you work faster. I'm using a Pixelbook, so most of my shortcuts will begin by typing control. For all Mac users, keep in mind that you're short guides will begin with command. For a complete list of shortcuts in both environments, check out the Google Help Center for keyboard shortcuts for Google Sheets. That link will be in the resources for you as well. We've also compiled a spreadsheet for you that contains a bunch of useful keyboard shortcuts that will be helpful no matter what operating system you're using. You can find that keyboard shortcut spreadsheet in the resources section of this course. It might be useful to bookmark it or keep it handy as you continue throughout the course, and we encourage you to use it after you successfully complete this course. Now let's start with the most popular shortcut I use: Ctrl + A or select all. You may want to use this feature if you want to change the font of the entire sheet at ones. The first time you use Ctrl + A, you will select content within the bounds of the table. If you hit Ctrl + A a second time, this will select the entire range of the sheet. Combining Ctrl and arrow keys will allow you to quickly jump locations in your sheet. So if we start on column A and hit Ctrl plus the right arrow, your cursor will jump the farthest adjacent cell location with a value. See? We just jump from column A to column N. Now say for example you want to skip down to the bottom of the list of movie titles to view the data on Zoolander who is at the very end here. So instead of scrolling all the way down each time, you can jump to the bottom of our table. If you hit Ctrl and down arrow, we will jump down from row 1 to row 509. This is incredibly useful when you have thousands or even hundreds of thousands of rows of data in a single spreadsheet. Let's practice navigating with the keyboard arrows. You can use your keyboard arrows to move around different cell locations. If you hit the right arrow, you'll move down from column A to column B. Likewise, if you hit the down arrow, you'll move from row 1 to row 2. Okay. Find and replace. Sometimes we can make mistakes entering data in other cell. I noticed we misspelled action in our genres columns. Whoops. For data analysis, since consistency is key, we need to go into the spreadsheet and change the incorrect spelling every single time it appears. Rather than panic, I can use the find and replace feature to make a bulk edit. This will save a lot of time. I don't have to hunt for each instance of the misspelled word. So Ctrl + F2 open the search bar, we'll select more options. Now we'll enter the original value in Find. So we misspelled action as actiom. So the misspelling would actually be the original value in our case. So let's enter that here. You'll see the option to enter a new value in Replace with. So this is where we correct the spelling. Let's enter action, spell it correctly as the new value. All right. Let's select replace all. We'll hit okay and all occasions of the misspelled genre are now corrected together as a batch, like magic. Continuing on the theme of correcting mistakes, let's look at the undo feature. Let's say you just did an action and wish to return. For example, we bolded this cell and wish to unbold it quickly. You can open the edit menu and select undo, this will undo your previous action. If you didn't mean to undo an action, you can click redo to restore it. All right. Congratulations. You made it through module 1. You should now feel comfortable creating spreadsheets, editing them, and printing and publishing them. Your test is coming up next.
