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, ...
How-To Geek on MSN
6 Excel features I use in every spreadsheet I create
Many Excel tools are optional extras, but these six are essentials I rely on in every workbook.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results