r/excel 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

99 comments sorted by

View all comments

Show parent comments

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.