exceltoxl.com

Hi there,

Hey! do you know the search box in Excel. Of-course we can do it through macros/vba but this is purely the option provided by the Microsoft itself.

To know where is this option, just walk with me. ..

...........................................

.........................................

......................................

...................................

................................

.............................

.........................

.....................

.................

..............

...........

........

......

....

...

..

.

...

Ok enough for now, relax and have a sip of tea and I will show you where it is.

Here we go:

This option is available in Filter Option.

DATA-->SORT & FILTER--FILTER (keyboard shortcut ALT + D + F + F)

Before filtering the required content, we can type in the search box and those "matching" words will appear in the filtered list.

One good thing here is that when typing the word, the matching words get filtered magically and get freezed when hit ENTER button. 

This is really cool right?

Note: This option is only available in version 2010 & 2013.

DOWNLOAD WORKING FILE.xlsx from here 

Keep Excelling....

Thanks,