Excel tip to filter with a search bar

The search bar function can be a great way to filter data in Excel. In this Excel tip, we'll show you how to use the search bar from the developer tab to filter data.

We'll walk you through the steps necessary to use the search bar to filter in Excel. After watching this Excel tip, you'll be able to filter easier in no time!

To get the developer tab: Right click at the top on the ribbon, and click customize ribbon. Then look in main tabs and check the box for the developer tab, and it will show up.

#excel #exceltips #exceltricks

[sarathlal]

It is really helpful. But I have a query, I am using Folder Name as B column and its SharePoint link as C column, how to hyperlink the C column so that it will be easy for navigation

[arghhass]

Does it need the linked form control or would it work just in a cell? Thanks

[lizard]

Hello, I want to merge cells even if they are in a formatted table and a normal range, please

[terry_the_terrible]

Thanks for the trick.
Any chance it can work with text in the middle ?

[jamiereife]

However, there isn’t really any need to add the developer search box. All you need to do is have a cell reference for the search criteria. Enter the name in the cell your formula refers to and you’ll get the same result