You are currently offline, waiting for your internet to reconnect

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

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q293450
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.
  • 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
kbnoOfficeAlertID inf XL2007 XL2003 XL2002

Article ID: 293450 - Last Review: 03/27/2007 21:42:33 - Revision: 2.0

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

  • kbhowto kbinfo KB293450