Excel's Find and Replace feature is a quick way of finding specific text and we can replace it with other text. We have to go to Special feature to quickly select all the cells with formkulas, comments, conditional formatting, constants and data validation etc.
Find in Excel
Follow the steps below to find text in Excel.
1. On the Home tab, in the Editing group, click Find & Select.
2. Click Find
3. The 'Find and Replace' dialog box appears.
3. Type the text you want to find. For example and when you find it
Excel selects the first occurrence.
4. Click 'Find Next'.
5. Click 'Find Next' to select the second occurrence.
6. To get a list of all the occurrences, click 'Find All'.
Replace in Excel
To quickly find specific text and replace it with other text, execute the following steps.
On the Home tab, in the Editing group, click Find & Select.
and you can replace the text you selected in find
Excel-Xpert is a all about excel, a professional series where everyone would get a chance to participate and we would try to explore and find new things, this would serve people who are keen to learn excel in detail.
Subscribe to:
Post Comments (Atom)
Excel formulas and functions
Excel formulas and functions Formulas and functions are the bread and butter of Excel. They drive almost everything interesting and useful...

-
Excel Ribbon can be accessed by selecting the ribbon's Home tab when you open it. Ribbon in excel is the name given to the row of tabs a...
-
1 Count and Sum : The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or mu...
-
Index Function in excel is used to return the value at a given position in a array. We can use excel index function with the MATCH function ...
No comments:
Post a Comment