Forum Discussion
kp1425
Jul 30, 2024Copper Contributor
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!
- JKPieterseSilver ContributorSlicers come to mind? Or teach people how to use control+F 🙂
- kp1425Copper ContributorI 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!