Feb 15 2023 05:14 PM
Why is it so hard to allow a developer to hide or disable filtering on some columns in a table? The arrow is ugly, when real estate is low and column widths are just wide enough to fit column names (headings) in the cell, the arrow obscures these headings.
Some data should never be filtered., the results would be pointless.
Is there a way to simply disable a filter ( I would use the word remove but most numb nuts on the internet have used that word to describe clearing a filter to make finding a real answer so much harder) on a specific column?
I have dress size information for cast of a play done by children and adults. I would like to be able to sort and filter by name, or by age group, by the scene they are in, but sorting by their Arm Length measurement is pointless. Why can a developer not simply disable filtering on columns that should not be filtered? Or have I missed something?
I need the data in these columns to filter but I don't want a control to filter by that column's data.
I need this at a developer level, not a user level, it is too hard to teach a user to manually apply a filter if they are not Excel savvy.
Feb 15 2023 06:27 PM
If I understand what you're asking, it sounds like a perfect application of the relatively new SORT and FILTER functions. Have your basic table uncluttered by those nasty little arrows, and create a separate sheet where you do your FILTERing and SORTing and display of what you, the developer, want to see.
Here's a YouTube video that was created by Microsoft back when these dynamic array functions were introduced. You will need Excel 2021 or newer.
Feb 15 2023 09:58 PM
Feb 16 2023 05:10 AM
I’m glad that video was both new and helpful. You’re clearly a more advanced user (as a developer for others, presumably as your work); I’m just a retired user, developing for myself. I also enjoy answering questions when I can. And then, too, I learn from watching what other pros do in this forum. Have learned a LOT in the last two years.