How to create a search bar for your data in #excel

to create a search bar, copy the headers choose a cell to place the search bar
choose developer / insert / textbox
now right click on the cell, properties / linked cell writes the cell address
in the first copied column write the formula
FILTTER ( Tablename, ISNUMBER (SEARCH (searchbar cell, tablename[column 1])) + ISNUMBER (SEARCH (searchbar cell, tablename[column 2])) ...

#excel #exceltips #exceltutorial