Find data

Office Web Components

Find data

  1. In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
  2. To search the entire spreadsheet, click a single cell, or, to search within a specific range of cells, select the range.

  3. On the toolbar, click Commands and Options Button image, and then click the Sheet tab.
  4. In the Find what box, type the text or value you want to find.

    Notes

    • By default, Find what searches for cells that include the value you enter in the Find what box. For example, an entry of "John" finds cells with strings such as "Johnson" or "Little John." If you want to find cells that contain only the value you entered and nothing else, select the Entire cell only check box.
    • By default, Find what is not case sensitive. If you want to find only those cells with values that match the case of your entry, select the Match case check box.
  5. Click Find Next.