Hosted on MSN

Creating drop-downs from table headers in Excel seems impossible—but this trick fixes it

You've built a perfect Excel table, but the moment you try to use its headers in a drop-down menu, everything breaks. Excel's Data Validation is notoriously picky with tables, but there's a clever ...
Hosted on MSN

Don’t ignore the power of F4 in Microsoft Excel

If you're using Microsoft Excel on a Windows PC and enjoy using keyboard shortcuts to improve your productivity, you should definitely learn the many ways in which F4 can save you lots of time. To ...