How-To Geek on MSN
Creating drop-downs from table headers in Excel seems impossible—but this trick fixes it
Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.
How-To Geek on MSN
This hidden right-click menu makes moving Excel data 10x faster
Stop manually inserting rows and columns—use Excel's "secret" right-click-drag menu to move, swap, and convert data instantly ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results