Microsoft Excel users, here’s a quick tip on adding a condition to a drop down list. You can use a Microsoft Excel drop down list to display a simple list, though sometimes you need a bit more control ...
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, ...
Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started. Spreadsheets usually hold a wealth of information, but it ...
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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results