how to use find replace option
Answers
1.From the Home tab, click the Replace command. ...
2.The Find and Replace dialog box will appear.
3.Type the text you want to find in the Find what: field.
4.Type the text you want to replace it with in the Replace with: field. ...
5.Word will find the first instance of the text and highlight it in gray.
Dear mates here is your answer
➡️FINDING DATA
Follow these steps to locate data in a worksheet:
⏩Choose Find & Select in the Editing group on the Home tab, and then select Find (or press Ctrl+F).
⏩The Find and Replace dialog box appears with the Find tab on top.
⏩In the Find What box, enter the data you want to locate.
⏩(Optional) Click the Options button to expand the dialog box and specify any desired options.
⏩Within: Search just the current worksheet or the entire workbook.
⏩Search: Select whether to search first across the rows or down the columns.
⏩Look In: Select whether you want to search through the values or formula results, through the actual formulas, or if you want to look in the comments.
⏩Match Case: Check this box if you want your search to be case-specific.
⏩Match Entire Cell Contents: Check this box if you want your search results to list only the items that exactly match your search criteria.
⏩Specify search options on the Find tab in the Find and Replace dialog box.
Specify search options on the Find tab in the Find and Replace dialog box.
Click Find Next.
⏩Excel jumps to the first occurrence of the match. If this is not the entry you’re looking for, click Find Next again. Excel advises you if it doesn’t locate the data you’re searching for.
⏩Click Close when you’ve located the entry you want.
➡️REPLACING DATA
️To find and replace data in a worksheet, follow these steps:
✔️Choose Find & Select in the Editing group on the Home tab, and then select Replace (or press Ctrl+H).
✔️The Find and Replace dialog box appears with the Replace tab on top.
✔️In the Find What box, enter the data you want to locate.
✔️In the Replace With box, enter the data with which you want to replace the found data.
✔️Use the Find and Replace feature to exchange data in Excel 2010.
Use the Find and Replace feature to exchange data in Excel 2010.
(Optional) Click the Options button and specify any desired options.
✔️Click Find Next to locate the first occurrence or click Find All to display a list of all occurrences.
✔️You can sort the results of a Find All search by clicking a column heading.
✔️If you want to use the replacement data, click Replace.
✔️Excel performs the replacement and locates the next occurrence.
✔️If you want to replace all occurrences at the same time, click Replace All.
✔️Excel displays an information box indicating the number of replacements made.
✔️Click OK in the alert box and then click Close.