Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Advanced Find and Replace in Excel 2007

In addition to performing a basic find and replace operation in Microsoft Office Excel 2007, you can use advanced search options (in the expanded Find and Replace dialog box) to carry out a more detailed search operation. For example, you can choose to display all found items within the dialog box, and you also can perform a search based on the cell formatting.

Find all data occurrences

To display a list of all occurrences of the data you want to find, follow these steps:

  1. Choose Find & Select in the Editing group on the Home tab, and then select Find (or press Ctrl+F).

    The Find and Replace dialog box appears.

  2. In the Find What box, enter the data you want to locate.

  3. Click Options and specify any desired options.

  4. Click Find All.

    The Find and Replace dialog box expands, showing a list of each cell entry that contains your data. You can sort the results by clicking a column heading. Also, you can click a cell in the list to jump to that cell.

    Use Find All to display a list of all found results in the Find and Replace dialog box.
    Use Find All to display a list of all found results in the Find and Replace dialog box.
  5. Click Close.

Locate cells based on formatting

Follow these steps to find worksheet data based on the formatting applied to that data:

  1. Choose Find & Select in the Editing group on the Home tab, and then select Find (or press Ctrl+F).

    The Find and Replace dialog box appears.

  2. Click Options.

    Verify that these options are the ones you want to use.

  3. Click Format.

    The Find Format dialog box appears.

    You can find cells in Excel 2007 based on Format options.
    You can find cells in Excel 2007 based on Format options.
  4. Select any formatting options for which you want to search.

    You can choose any combination of options.

  5. Click OK.

    A preview of the formatting appears in the Preview box.

  6. In the Find What box, enter the value or word you want to locate.

    Leave this blank if you want to locate every cell with the specified formatting, regardless of the cell contents.

  7. Click the Find or the Find All button. Then click Close.

You also can perform a find and replace operation that replaces the found data with the text and formatting you specify. To do so, specify Format options for both Find What and Replace What on the Replace tab of the expanded Find and Replace dialog box.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.