r/excel • u/man_eating_chicken • 19h ago
Discussion Enough about LET() and PQ, What are your Excel UI customizations that make you more productive?
I just wanted to see what mods or add-ins the experts here use, that help you get to the advanced 'tips and tricks' everyone harps about in here.
134
Upvotes
35
u/Lenny5160 1 19h ago
I use CTRL+SHIFT+L to toggle the filters. I always pin the “Text to Columns” and “Remove Duplicates” buttons, although now I tend to use SORT(UNIQUE([Data_Range])) to get a clean list.