Microsoft KB Archive/293450

= Frequently asked questions about the &quot;Find and Replace&quot; feature in Excel =

Article ID: 293450

Article Last Modified on 3/27/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q293450



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 &quot;Find and Replace&quot; feature in Excel.



MORE INFORMATION
 How do I use the new Find and Replace dialog box?

288291 How to use the &quot;Find and Replace&quot; 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 &quot;find&quot; 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 &quot;Microsoft Excel cannot find a match&quot; 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



Additional query words: kbnoOfficeAlertID inf XL2007 XL2003 XL2002

Keywords: kbhowto kbinfo KB293450

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.