• Excel Video Tutorials

Find & Replace in Excel 2010


MS Excel provides Find & Replace option for finding text within the sheet.

Find and Replace Dialogue

Let us see how to access the Find & Replace Dialogue.

To access the Find & Replace, Choose Home → Find & Select → Find or press Control + F Key. See the image below.

Find option in MS Excel

You can see the Find and Replace dialogue as below.

Find Tab in Excel

You can replace the found text with the new text in the Replace tab.

Replace Tab in Excel

Exploring Options

Now, let us see the various options available under the Find dialogue.

  • Within − Specifying the search should be in Sheet or workbook.

  • Search By − Specifying the internal search method by rows or by columns.

  • Look In − If you want to find text in formula as well, then select this option.

  • Match Case − If you want to match the case like lower case or upper case of words, then check this option.

  • Match Entire Cell Content − If you want the exact match of the word with cell, then check this option.

Various Find options in Excel

Useful Video Courses


MS Excel Online Training

Most Popular

102 Lectures 10 hours

Pavan Lalwani


Excel VBA Online Training

101 Lectures 6 hours

Pavan Lalwani


Advanced Excel (Power Query) Online Training

Best Seller

56 Lectures 5.5 hours

Pavan Lalwani


Excel Dashboard Crash Course

63 Lectures 3.5 hours

Yoda Learning


Advanced Excel Crash Course

134 Lectures 8.5 hours

Yoda Learning


Microsoft Excel Masterclass for Business Managers

33 Lectures 3 hours

Abhishek And Pukhraj