Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Another powerful search tool comes within the file. Once you've found the file you're looking for, searching within that file is a breeze. You can go up to the Edit menu and choose either Find or Replace. Replace is Find and Replace and it opens up the same dialog box, regardless of what you choose. Let me choose Replace. You'll see that the Find tab and Replace tab are two halves of the same dialog box. So in this case, I'm going to search for the words Richard H. and replace that with Susan B. Let's see what options we have for this search. So I can search within this sheet or within the entire workbook. I can search by rows or columns, and I can have it look in formulas. We can specify a match case if there are uppercase and lowercase versions of your search strings and we can specify certain formats, which we'll talk about in a moment. Let's find. When I click Find Next, sure enough it jumped right up to Richard H.vand I'm going to replace that value and then close the search engine, and I've successfully found and replaced a piece of text within my spreadsheet. If I want to find numerical data within my sheet, I can go back to that same dialog box. This time I'll just simply use the Find. The options are already open so I can look for a particular numerical format. Let's say I'm looking for the number 38, and the format I'm looking for, I'll choose Format for the Format dialog box, and it opens up a dialog box that looks very much like the Format Cells dialog box, and in this case I'm going to look for a background color that looks like this. I can also choose a format from an existing cell, if I wish. Let's say OK. The value's 38, the background color is this, so it will not look for 38 without that color background, and let's Find. And there it goes. Let me move the dialog box so we can see everything. It's found two values. One at E6, which is currently highlighted, and if I go to Find Next, the other value is at H12. Last not least, let me close this dialog box, something that is potentially very powerful is the Go To search, which will allow you to search for special cells and characters. If you go up to the Edit menu, the last option here in this division is Go To, and if we select that, the Go To dialog box, we've used it for other things, in this case we're going to click Special, and when we do, you can see that we can go to cells that have special formatting or attributes. For example, we can look for the blanks within this file and click OK, and all the blank files have been selected. Very fast, very easy and I have a comprehensive look at the spreadsheet using that special search.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 99024 Viewers
80 Video lessons · 141743 Viewers
59 Video lessons · 60101 Viewers
52 Video lessons · 73251 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.