How-To Geek on MSN
Years later, this is still one of my most-used Excel tools
Excel's old-school Custom Lists feature still solves modern problems by automating entries and customizing sorting.
Hosted on MSN
I didn't realize Excel could sort by multiple columns this easily — now I use it constantly
For many of us, sorting an Excel spreadsheet alphabetically means clicking the A→Z or Z→A buttons in the Sort & Filter group and moving on with our day. I used to think that was the extent of what ...
Traditional methods for creating dynamic drop-down lists in Excel, such as using INDIRECT or named ranges, often come with significant limitations. These approaches can break when tables are renamed, ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results