Find and Replace is very useful option, which allows you to find some content in the Excel Sheet and you can replace the content with content all at once.
The following steps will illustrate how to access and use this option along with screen shots.
To launch the dialog box for Find and Replace, go to the Home option or top left corner beside file and open Click Find. You can also use the short cut keys Ctrl + F on the keyboard as shown in the figure below.
This will open the Find and Replace dialogue box as shown below:
The Replace option is provided just on the right side of the Find in the new Replace tab. Type the text in “Replace” that you want to put in place of the original content in the cells.
Let us now explore the various options that are listed under the Find Tab in Find and Replace Dialog Box.