Hosted on MSN

Excel's data validation is far more powerful than just dropdowns — here's what it can actually enforce

Most people set up a dropdown list to make spreadsheets smarter with Excel's data validation. However, the Custom option in the Data Validation dialog accepts any formula that returns TRUE or FALSE, ...
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 ...