FIND AND REPLACE
After learning this, you can easily find any word in your EXCEL SHEET and can also REPLACE any word from another word.
By USE FIND, we can easily FIND any word in our Excel sheet.
To go to
STEP -1 # FIND OPTION, first we will CLICK on FIND & SELECT OPTION in EDITING BLOCK of HOME TAB.
STEP -2 # THEN CLICK ON FIND.
STEP -3 # Then after CLICK on FIND, we face OPTION of FIND.
To OPEN OPTION of this FIND is SHORT KEY (CTRL + F).
STEP -4 # Then the word we want to FIND, we will TYPE that word here and CLICK on FIND NEXT.
As soon as CLICK on FIND NEXT, the word where it is in the entire excel sheet becomes CELL SELECT. So in this way we can easily FIND any word by using USE of this FIND OPTION.
Now we will know how to replace any word in EXCEL meaning how a word is written in place of another word.
It is very easy to replace any word in EXCEL. For this we can easily replace any word with just 4 steps.
STEP -1 # First we will click on find & select in the editing block of home tab.
STEP -2 # Then click on Replace.
STEP -3 # Replace the option as soon as we click CLICK on Replace. (The short cut key to go to the Replace opiton is ctrl + h. Using this we can also go directly to the Option of Replace)
STEP -4 # After the option of Replace, we have to fill two options in it. First of all we have to write the word in find what above which we have to remove from our excel sheet and in the below Replace with we have to write the word which we have to write instead of that earlier word.
After filling both the options, we will click on replace all and on clicking, in our sheet, wherever the word above is written, it gets replaced with the word written below.
So in this way we can find any word using find and replace options and can easily replace any word with another word.
Come see how much you learned in FIND AND REPLACE
CLICK ON START QUIZ TO START THE QUIZ