Lesson 8 continuation

Using the Find All Command

1.Select the range of cells you want to search in.

2.Click on EDIT-> REPLACE

3.Type the text or numbers that you want to search for in the find box or choose a recently searched for item from the find what drop down.

4.Click on the FORMAT button to specify a format for your search and make selections on the FIND format dialog box.

5.Select OPTIONS to further refine your search.

6.Type the replacement text, characters members in the replace with box and choose specific format if necessary.

7.Click on the Find Next or Find All button.

8.Click on the Replace button or Replace All button to replace the highlighted occurrence or all occurrences of the found characters.