Search Bar In Excel

Steps to create a search bar in Excel

• Step 1: Create a table by selecting your data and pressing Ctrl + T, then click OK to confirm.
  (This makes it easier to use structured formulas later.)
• Step 2: Go to the Developer tab, click Insert, and choose the Text Box under ActiveX Controls.
• Step 3: Drag and drop the Text Box anywhere on the sheet — remember the cell it's placed on (e.g., F4).
• Step 4: Right-click the Text Box and choose Properties. In the LinkedCell field, type the reference of the linked cell (e.g., F4), then close the Properties window.
• Step 5: Go to the Developer tab again and turn off Design Mode.
• Step 6: Click on a cell below your table header, and type the following formula:
  

  =FILTER(MyTable, ISNUMBER(SEARCH(F4, MyTable[FirstColumn])), "NOTFOUND")

Result: The table will dynamically display rows that match the search term you type in the text box.

Tip: Make sure to replace MyTable, FirstColumn, and F4 with your actual table name, search column, and linked cell reference.