What is Find and Replace in MS Excel?

In Ms Excel Find & Select is a feature that enables you to quickly find specific text, and replace it with the other text. Especially this is useful when your spreadsheets contain on a large number of data and you need to change certain text on several places repeatedly.

Suppose by mistake you typed a wrong text or value on your worksheet and you want to change it now. Instead of read and typed manually for the correction you just go in Home Find & Replace tab select find and then type wrongly entered data and then replace it with correct word.

Further, you can replace one by one or can use replace all option.

The short cut key for Find & Replace is, > Ctrl+F

find and replace in excel

Please see the below images.

what is find replace and how it works in ms excel

Another option in Find & Replace is you can use Excel's Go To Special feature to quickly find & select all cells which are containing with formulas, comments, conditional formatting, constants, data validation, etc.

Also Read:
What Is Pivot Table In Excel
How To Insert Picture In Excel
oemwes.blogspot.com