Frequently asked questions about the "Find and Replace" feature in Excel

Article translations Article translations
Article ID: 293450 - View products that this article applies to.
This article was previously published under Q293450
Expand all | Collapse all

SUMMARY

In Microsoft Office Excel 2007, in Microsoft Office Excel 2003, and in Microsoft Excel 2002, the Find and Replace dialog boxes of earlier versions of Excel have been replaced by a single dialog box. The default tab selection depends on which of the two commands is used to open the dialog box. You can switch between finding and replacing as needed.

This article also lists articles that address some of the more frequently asked questions about the "Find and Replace" feature in Excel.

MORE INFORMATION

  • How do I use the new Find and Replace dialog box?
    288291 How to use the "Find and Replace" dialog box in Excel
  • Why are cells on unselected sheets changed when I perform a find-and-replace operation?
    284881 The matching cell in the unselected worksheets are also replaced when you click the Replace All button in the Find and Replace dialog box in Excel
  • Why aren't all cells with the same formats found when I choose to "find" based on the formatting of a cell?
    283626 You can only find the cells that exactly match the formatting based on the existing cell in Excel
  • Why doesn't the Replace command find text that I know is in my workbook?
    287126 "Microsoft Excel cannot find a match" error message
  • Why doesn't the Find command locate text that I know is in my workbook?
    282142 You cannot find the data that is in a filtered list by using Find command in Excel

Properties

Article ID: 293450 - Last Review: March 27, 2007 - Revision: 2.0
APPLIES TO
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
Keywords: 
kbhowto kbinfo KB293450

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com