Forum Discussion

kp1425's avatar
kp1425
Copper Contributor
Jul 30, 2024

Making spreadsheet searchable w/o macros?

I'm looking to create a search box and possibly dynamic buttons like "filter" and "clear" as well within my spreadsheet. However, the problem is that this document will ultimately be shared widely and having people keep track of a macro file is really not realistic. So, I'm wondering what options there are to creation enhanced searchability within a spreadsheet without the use of macros. Is the sort/filter function the only option? 

 

Thanks in advance!

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Slicers come to mind? Or teach people how to use control+F 🙂
    • kp1425's avatar
      kp1425
      Copper Contributor
      I somehow had no idea slicers existed. That's a nice function! It unfortunately isn't compatible with this table though, which I'm only now realizing isn't even technically a table. On top of that, we need to be able to search for a single value within cells that have multiple values listed. It's a mess. Hence the macros I guess.

      Looks like I'm going to be teaching some people how to use control+F. Thanks for turning me on to slicers though!

Resources