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 🙏

[@victorcuevas5179]

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

[@spreadsheet_power]

Thank you

[@samirawati1975]

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

[@spreadsheet_power]

Thanks and welcome

[@ibrahimmd759]

Excited by your teach, thank you very much

[@spreadsheet_power]

Welcome 🙏

[@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

[@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

[@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.

[@mabuhayka]

Thank you so so much, highly recommended.

[@spreadsheet_power]

Glad you enjoyed it!

[@balajipalani8972]

Please make the video for without filter function

[@aarondrost963]

Worked for me. Thank you so much

[@spreadsheet_power]

Welcome 🙏

[@balajipalani8972]

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

[@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

[@stemariemasong1255]

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

[@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!

[@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!

[@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.

[@AliKhanYousufi-my4we]

Please you can which use version excel

[@spreadsheet_power]

I have done this in Excel 365

[@surinderkumar1279]

How to add field name

[@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.

[@bishnupaswan514]

Thank you so much ❤Sir

[@spreadsheet_power]

Welcome

[@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

[@wilsonco3078]

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

[@spreadsheet_power]

Which Excel version are you using?

[@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.

[@JM-pf2uj]

Thank you so much sir!!

[@spreadsheet_power]

Most welcome!

[@mollydoug4281]

What is your version of Excel?

[@spreadsheet_power]

It is Microsoft 365

[@ShanmugaPriya-y1m]

Thanks for your support

[@spreadsheet_power]

Thank you too

[@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.

[@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.

[@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

[@ColorfulShades-rainbow]

Thank you sir

[@spreadsheet_power]

Welcome

[@muhammadyounas7270]

Filter function is not available in excel

[@spreadsheet_power]

For this, you need to have latest Excel version

[@mathspuzzlesbrainquistive2288]

GOOD One

[@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.

[@shahzadamuzzammiltariqbutt1995]

This formula is not working in Excel verson 2019

[@spreadsheet_power]

Yes, for this latest Excel version is required

[@tempatnugasnisa5386]

❤

[@spreadsheet_power]

❤️

[@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.

[@rcsontag]

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

[@SunilKumarBhoi-ej9ur]

Faltu decribing