How to Make Search Bar in Excel (All Column Search)

[@yasirmehmood6694]

thanks for sharing such great knowledge, please keep sharing, thanks again,

[@spreadsheet_power]

Welcome 🙏

[@Jhon-it3ps]

Thank you so much dude, hope you live a long life ❤❤❤

[@spreadsheet_power]

Thank you too

[@victorcuevas5179]

Hands down, phenomenal! I never subscribe to anything, but you sir, have my support!

[@spreadsheet_power]

Thank you

[@ibrahimmd759]

Excited by your teach, thank you very much

[@spreadsheet_power]

Welcome 🙏

[@julianvargas2401]

Excellent video! I have an issue with the 'Text Box'. I made the search bar but after I click on the 'Design Mode' to deactivate it and enter text in the activeX text box, the cursor does not show. I type and no text appears in the Text Box. I can see the text typed into this box show on the 'LinkedCell' but not within the actual Text Box. I'll be grateful for any help.

[@spreadsheet_power]

please check the fore color property of text box, it may be set as white. Try changing the color and see if it works.

[@balaandrews]

Hi bro, no filter function on excell 2019 version. So plz share alternate function using search bar options, plz make a video or share ur idea on how to make other functions using .... Thank U

[@cezarantoin3559]

The same problème with me

[@IstvanLadunga]

Hi, it is really useful. If I got a bigger table, is there a way to exclude one or more specific columns from the result of the search? Thanks

[@spreadsheet_power]

To Exclude column, while writing the formula, do not take the columns that you want to exclude.

[@muhammadasif4916]

You are super super awesome my brother..... thank you so much for sharing your knowledge and excel files Bless you

[@spreadsheet_power]

I appreciate that!

[@samirawati1975]

gr8 sir... that's very easy and 100% working... keep it up

[@spreadsheet_power]

Thanks and welcome

[@kobbyg6487]

worked for me, i have a question, what if I don’t want the table to appear unless I search for something

[@MahboubehZarei-e9w]

Love your easy explanation. Could you please provide us some video for creating search box with navigating through many sheets as well? Tnx👌👌👌

[@spreadsheet_power]

Noted. Thanks for the suggestion

[@anupacharya1746]

great tool indeed, just qns, for any blank columns in source data table, the value is coming as 0 in result column, how to suppress the 0 value? Appreciate your help here

[@mabuhayka]

Thank you so so much, highly recommended.

[@spreadsheet_power]

Glad you enjoyed it!

[@kwamekyei-brefo1501]

Please sir, is there any way where you can search for date without converting it to number format?

[@cezarantoin3559]

What IS your excel version ? I have excel 365 but i cannt find the fonction filter ?!

[@spreadsheet_power]

Filter function should be in Excel 365, is your software updated?

[@aarondrost963]

Worked for me. Thank you so much

[@spreadsheet_power]

Welcome 🙏

[@IMMORTALRECAP56]

sir, i used ms office 2016 and there are no filter formula available only available filterxml, please tell me how i supposed to do this ??

[@spreadsheet_power]

Filter function is available in latest Excel versions, hence, this method can't be used in old Excel. I will upload a tutorial if I found any alternative method that applies to old versions too.

[@alessiameloccaro7119]

@@spreadsheet_power E' possibile introdurla in una versione di excel meno recente tramite UDF?

[@lilacalii]

It worked, but why the data source from the table doesn't show all the search data in the search box?

[@spreadsheet_power]

It should show all data, could you share your working sheet in [e-mail] ? Will check and revert.

[@shoga63]

Hi Mr PK , I cannot seem to enter text into the text box after I come out of the design mode, I am using Excel for office 365

[@spreadsheet_power]

This might be because ActiveX control is disabled. Check it on File/Options/Trust Center/Trust Center Setting/ Enable it if disabled and see if it works.

[@vinodhkumar9017]

thks bro.

[@spreadsheet_power]

Welcome

[@balajipalani8972]

Please make the video for without filter function

[@AliKhanYousufi-my4we]

Please you can which use version excel

[@spreadsheet_power]

I have done this in Excel 365

[@surinderkumar1279]

How to add field name

[@Romie1125]

How do you write the star symbol 😭 please answer

[@spreadsheet_power]

Normally, it is in the number 8 key in keyboard. Need to type it with SHIFT key.

[@balajipalani8972]

I don’t have filter function why ? and how to do without the function or is it possible to get that function

[@_-wv4ez]

The link is not working, please update. Thank you.

[@spreadsheet_power]

The link should be working fine. What error did you get?

[@bishnupaswan514]

Thank you so much ❤Sir

[@spreadsheet_power]

Welcome

[@benjiealvarez6229]

thank you so much, its help me alot superb tutorial and its easy to follow your steps. by the way you can add in your video on how to put developer tab most of us doesn’t show that tab.💯👏♥️

[@spreadsheet_power]

Thanks for the tip!

[@wilsonco3078]

can you create a 2024 excel? filter is not working anymore

[@spreadsheet_power]

Which Excel version are you using?

[@stemariemasong1255]

And how to ths steps? If you have multiple, or double header in your table?

[@myneninagasivasai1414]

great video sir but i have a small dout is this dynamic

[@spreadsheet_power]

Dynamic in a sense, it is able to search and display values automatically

[@mollydoug4281]

What is your version of Excel?

[@spreadsheet_power]

It is Microsoft 365

[@naveenkumarm1229]

Nice video keep it up. How to remove copy past option in search bar only typing opination should be there. pls help me with this. thanks

[@ShanmugaPriya-y1m]

Thanks for your support

[@spreadsheet_power]

Thank you too

[@eating_habits]

the formula worked but instead of month some numbers are appearing. how can I resolve that?

[@spreadsheet_power]

This is due to cell formatting, select the column and change cell format to date

[@JM-pf2uj]

Thank you so much sir!!

[@spreadsheet_power]

Most welcome!

[@stemariemasong1255]

Hi.. im from philippines.. what to do, in my Excel i Don't have "FILTER" Function , pls...help

[@spreadsheet_power]

Unfortunately, filter function is not available in old Excel versions, to use this, you should have lateat version.

[@ColorfulShades-rainbow]

Thank you sir

[@spreadsheet_power]

Welcome

[@abohamza8177]

Dear this not work in excel on mac Could you please tell us how to do it on mac

[@spreadsheet_power]

In which part this didn't work? Any function not available or the same formula didn't work? Could you explain?

[@abohamza8177]

@spreadsheet_power developer part not complete in Ios excel

[@lojada]

اشكرك ارجو الترجمه الي اللغه العربيه يمكن استخدام الترجمة الصوتيه العربيه

[@spreadsheet_power]

Thank you for the suggestion

[@muhammadyounas7270]

Filter function is not available in excel

[@spreadsheet_power]

For this, you need to have latest Excel version

[@shahzadamuzzammiltariqbutt1995]

This formula is not working in Excel verson 2019

[@spreadsheet_power]

Yes, for this latest Excel version is required

[@AliKhanYousufi-my4we]

Excuse me Please you can uploading link download office 365 this comment Thanks Please

[@spreadsheet_power]

Hi, office 365 is available in Microsoft official website, but you have to purchase the licence.

[@tempatnugasnisa5386]

❤

[@spreadsheet_power]

❤️

[@mathspuzzlesbrainquistive2288]

GOOD One

[@hemchhun9497]

My Excel has no FILTER formulas

[@spreadsheet_power]

To get access to filter function, you have to purchase latest Microsoft Excel version, or use the web version of Excel.

[@aaryo4365]

WAW

[@rcsontag]

This demonstrates how to use the FILTER function, not how to search!

[@SunilKumarBhoi-ej9ur]

Faltu decribing

[@shridharchannannavar2856]

I'm facing problem,,once done it's showing #SPILL! In the cell

[@spreadsheet_power]

Spill error happens due to blockage in the range where the result is trying to populate. Make sure all cells are blank (right and down) from the first formula cell.