How to search any word in Excel using “Find”

image_pdf

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

How to delete all rows with name "Shruti"


 

695 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>