How-To Geek on MSN
Microsoft Excel's selection pane: The best tool you didn't know you had
Instead of losing your mind, use the Selection Pane, the hidden sidebar that reveals every object on your sheet so you can ...
How-To Geek on MSN
Excel's UNIQUE function can't skip columns—unless you use this trick
Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.
Keyboard shortcuts can supercharge your workflow - if you know what they are. Here are the ones I recommend to every user.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback