![]() You can open the edit menu and select undo, this will undo your previous action. For example, we bolded this cell and wish to unbold it quickly. Let's say you just did an action and wish to return. Continuing on the theme of correcting mistakes, let's look at the undo feature. We'll hit okay and all occasions of the misspelled genre are now corrected together as a batch, like magic. Let's enter action, spell it correctly as the new value. So this is where we correct the spelling. You'll see the option to enter a new value in Replace with. So the misspelling would actually be the original value in our case. ![]() Now we'll enter the original value in Find. So Ctrl + F2 open the search bar, we'll select more options. I don't have to hunt for each instance of the misspelled word. Rather than panic, I can use the find and replace feature to make a bulk edit. For data analysis, since consistency is key, we need to go into the spreadsheet and change the incorrect spelling every single time it appears. I noticed we misspelled action in our genres columns. Sometimes we can make mistakes entering data in other cell. Likewise, if you hit the down arrow, you'll move from row 1 to row 2. If you hit the right arrow, you'll move down from column A to column B. You can use your keyboard arrows to move around different cell locations. Let's practice navigating with the keyboard arrows. This is incredibly useful when you have thousands or even hundreds of thousands of rows of data in a single spreadsheet. If you hit Ctrl and down arrow, we will jump down from row 1 to row 509. So instead of scrolling all the way down each time, you can jump to the bottom of our table. 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. See? We just jump from column A to column N. 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. ![]() Combining Ctrl and arrow keys will allow you to quickly jump locations in your sheet. If you hit Ctrl + A a second time, this will select the entire range of the sheet. The first time you use Ctrl + A, you will select content within the bounds of the table. You may want to use this feature if you want to change the font of the entire sheet at ones. Now let's start with the most popular shortcut I use: Ctrl + A or select all. 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. You can find that keyboard shortcut spreadsheet in the resources section of this course. 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. That link will be in the resources for you as well. For a complete list of shortcuts in both environments, check out the Google Help Center for keyboard shortcuts for Google Sheets. For all Mac users, keep in mind that you're short guides will begin with command. I'm using a Pixelbook, so most of my shortcuts will begin by typing control. Now that we've learned how to navigate our spreadsheet, let's learn some shortcuts that'll help you work faster. 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. In this video, we're going to discuss some basic keyboard shortcuts. Resize the formula bar (move up or down).Hello again. Toggle formula result previews (when entering a formula).Ĭtrl + Option + Up or Ctrl + Option + Down Show/hide formula help (when entering a formula).įull/compact formula help (when entering a formula).Ībsolute/relative references (when entering a formula). Insert columns to the left (with columns selected). Open the drop-down menu on a filtered cell.Īlt + I, then w or Alt + Shift + I, then W Move focus to a popup (for links, bookmarks, and images). Move to quick sum (when a range of cells is selected). Option + Shift + 7 or Command + Shift + 7Ĭommand + Option + Shift + Semicolon ( ) ![]() ![]() Input tools on/off (available in spreadsheets in non-Latin languages). Open the Sheet menu (copy, delete, and other sheet actions). Open the Accessibility menu (present when screen reader support is enabled). Open the Delete menu with cells selected.įorm menu (present when the spreadsheet is connected to a form). Open the Insert menu with cells selected. To do so, go to Help → Keyboard shortcuts (or use Ctrl +/) shortcut and then turn on Enable compatible spreadsheet shortcuts. Apart from the below-mentioned keyboard shortcuts, you can also use keyboard shortcuts made by other apps/companies in Google Sheets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |