Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Excel
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Product Information
Help and How-to
Choose your version
Training
Templates
Related Products and Technologies
Support and Feedback
Technical Resources
Additional Resources
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Find cells that match a format
 
  1. Click Find on the Edit menu.
  2. Clear the Find what box.
  3. Do one of the following:
    • To specify a format, click Options, click Format, and then set your options in the Find Format dialog box.
    • To point to a specific cell format as an example, click the arrow next to Format, click Choose Format From Cell, and then click the cell.

    Note  The format for the search is displayed in the Preview box.

  4. Click Find All or Find Next.

    Find All lists every occurrence of the item you are searching for and allows you to make a cell active by selecting a specific occurrence. You can sort the results of a Find All search by clicking a header.

See Also
advertisement
Printer-Friendly VersionPrinter-Friendly Version