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.
No comments:
Post a Comment