Find and replace


show more Find and replace provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training show less
please wait ...

Find and replace

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...

Find and replace
Video duration: 3m 9s 4h 8m Beginner

Viewers:

Find and replace provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...