« Insert Symbols to Custom Number Formatting | Turn On Conditional Formatting » |
Search Box in Excel 2010 & 2013
Excel Tips, Excel2013, 2010Hi 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,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments