If you want to quickly find specific text in excel from database, then find feature is very useful
1. Press Ctrl+F and write your text in dialog box. Click OK.
If you want to find text from particular column or from an array, Select that column and Click OK.
Excel will navigate to the required cell and Select it.
If there is more than one answer of your search, you can use "Find Next" to go to next search option.
To quickly see all the search answers, click on "Find All".
It will give the list of cells where required search is found.
Here we have search "Shruti" in cell $B$22 and $B$26. Press Ctrl+A to select both cells.
Explore more, It's Amazing
695 total views, 1 views today