Excel 2010 Just the Steps For Dummies
Book image
Explore Book Buy On Amazon

In addition to performing a basic find and replace operation in Excel 2010, you can use advanced 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. Press Ctrl+F to open the Find and Replace dialog box.

  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.

Locate cells based on formatting

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

  1. Press Ctrl+F to open the Find and Replace dialog box.

  2. Click Options.

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

  3. Click Format.

    The Find Format dialog box appears.

  4. Select any formatting options for which you want to search.

    You can choose any combination of options, including fill color.

    You can find cells in Excel 2010 based on Format options.
    You can find cells in Excel 2010 based on Format 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 all cells with the specified formatting, regardless of the cell contents.

  7. Click the Find or the Find All button.

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.

About This Article

This article is from the book:

About the book author:

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988, that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics areas of computing. She also provides training and support for Peachtree Accounting Software. Diane's authoring experience includes over 40 books on topics, such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of these titles have been translated into other languages, such as French, Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Diane and her husband enjoy spending their free time fishing, traveling, and playing with their four grandsons and their Yorkshire Terrier.

This article can be found in the category: