Teach Yourself Excel Lesson 23 - Find And Replace

Find And Replace
Suppose I've changed my mind and now prefer to use the term "Entertainment" instead of "Eating Out"
How do I do this ?
Easy..
- Press CTRL + H to find and replace data..
- in Find What, type: Eating Out
- In Replace with, type: Entertainment
- Press ALT + A
Result:
NOTE:
- Find and Replace does not replace within the Data Validation, so you will need to change that in column B.
Your sheet should now look like this
Next Lesson: Teach Yourself Excel Lesson 24 - Inserting And Renaming Worksheets
Training Video on how to Find And Replace in Excel:
Attachment | Size |
---|---|
find-and-replace.xls | 21.5 KB |
»
- Nick's blog
- Login or register to post comments
- 9558 reads
Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 47 weeks ago
6 years 50 weeks ago
6 years 51 weeks ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago