Find and Replace

The Find and Replace dialog displays when the Edit | Find or Edit | Replace commands are selected. The Find and Replace dialog is used to search and replace specific numbers or text in the worksheet.

 

The Edit | Find Next command is used to find the next instance of a particular number, word, or phrase in the worksheet. If the Edit | Find command was not used initially, the Find and Replace dialog opens so that you can define your search criteria.

 

The Find Page

Clicking the Edit | Find command, pressing CTRL+F on the keyboard, clicking the Edit | Find Next command, or clicking the F3 key on the keyboard, opens 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 objects, 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 column or to the right across rows by selecting By row.

 


In this example, cell A2 is selected. If the
Find
criteria is "0", and
By column is the search
order, cell A4 is found first. If By row is the
search order, cell B2 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. The 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.

 

See Also

Find Next

Replace

Edit Menu Commands - Worksheet