Forum Discussion
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 an...
Slicers come to mind? Or teach people how to use control+F 🙂
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!
Looks like I'm going to be teaching some people how to use control+F. Thanks for turning me on to slicers though!