FIND AND REPLACE

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.

1. FIND.

2. REPLACE.

1 -HOW TO USE FIND .

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.

UNDO/REDO AND GOTO

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).

FIND AND REPLACE

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.

2 -HOW TO USE REPLACE 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.

UNDO/REDO AND GOTO

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)

find and 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.

For More Information see video

Come see how much you learned in FIND AND REPLACE

CLICK ON START QUIZ TO START THE QUIZ 

Leave a Reply

© 2020 NtOffice.in         ।     All Rights Reserved.

ABOUT US    ।    CONTACT   US   ।    TERMS  OF  USES   ।  DISCLAIMER   ।  PRIVACY  POLICY

WhatsApp
Google+
Facebook
Telegram