MS Excel - Find & Replace
MS Excel Provides Find & Replace option for finding text within the sheet.
Find and Replace DialogueLet us see how to access Find & Replace Dialogue.
To access the Find & Replace, Choose Home -> Find & Select -> Find or press Control + F Key.See below image.
You can see the Find and Replace dialogue as below.
You can replace the found text with the new text with Replace tab
Now Let us see 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 options
Match Entire Cell Content: If you want to exact match of the word with cell then check this option.