Find and Replace Dialog

The Find and Replace dialog displays when the Data | Find | Find, Data | Find | Find Next, or Data | Find | Replace commands are chosen. The Find and Replace dialog is used to search for and replace specific text in the worksheet.

 

The Find Page

The Data | Find | Find and Data | Find | Find Next commands open the Find page of the Find and Replace dialog.

 

Search for and replace specific text in the

worksheet with the Find and Replace dialog.

 

Find

To find a word or phrase, type the text you want to search for in the Find field. Click the arrow at the right to select from a list of the most recently used text strings. The asterisk * and question mark ? wildcards can be used in the Find box. Click the arrow at the right to select from a list of the most recently used criteria.

In

Next to In, choose the parameters of the search from the list. Choices include The column where active cell is, The row where active cell is, and The entire limits.

 

Search Order

The Search order controls the direction of the search: down through columns by selecting By columns or to the right across rows by selecting By rows.

 

In this example, cell A1 is selected.

If the Find criteria is "7", and

By Column is the Search order, cell

A5 is found first. If By row is the

Search order, cell B1 is found first.

 

Match Case

If you have case sensitive characters in the Find text string, check the Match case check box. Selecting Match case distinguishes between uppercase and lowercase characters. For example, a search for "Elevation" with the Match case option selected will not find entries for "elevation", but will find entries for "Elevation".

 

Deselect All First

Check the Deselect all first box to deselect all selected cells before performing the search. All previously selected cells will be deselected prior to the search when the Deselect all first check box is checked. If the Deselect all first box is deselected, the results of a previous search will remain highlighted when performing the next search.

 

Method

Choose the search Method from the list to determine how the search is performed.

 

This examples assume "Golden, CO" is in the Find field.

 

Find All Button

Click the Find All button to find all occurrences of the Find criteria in the worksheet. All of the cells that contain the Find criteria will be highlighted.

 

Find Next Button

Click the Find Next button to find the next occurrence of the characters specified in the Find box. This allows you to meet the criteria one at a time. The next instance of the Find criteria will be highlighted.

 

Close Button

Click the Close button to exit the Find and Replace dialog.

 

The Replace Page

The Data | Find | Replace command opens the Replace page of the Find and Replace dialog. The Replace page has all of the Find page fields, with the addition of the Replace with field. The Replace page, Method field has only two options.

 

Replace numbers or text in the worksheet

with the Find and Replace dialog.

 

Replace With

Type the text you want to replace in the Find box. To delete the characters in the Find box from your worksheet, leave the Replace with box blank. Click the arrow at the right to select from a list of the most recently searched items.

 

Replace Button

Click the Replace button to replace the selected occurrence of the criteria in the Find box with the criteria in the Replace with box, find the next occurrence of the criteria in the Find box, and then stop. If you want to automatically replace all occurrences of the search criteria in the worksheet, click the Replace All button.

 

Replace All Button

Click the Replace All button to replace all occurrences of the Find criteria in your document with the Replace with criteria. If you want to review and selectively replace each occurrence, click the Replace button.

 

 

See Also

Find

Find Next

Replace

Data Tab Commands