How-To Geek on MSN

Microsoft Excel's selection pane: The best tool you didn't know you had

Manage layers, hide overlapping charts, and find ghost objects using Excel’s powerful Selection Pane.
Houston Chronicle

How to Make a Drop-Down List Change Depending on Selection in a Different List in Microsoft Excel

The Data Validation feature in Excel 2013 offers a List option to confine selections in a cell to a preconfigured series of values. This selection can further influence the values in another list by ...
How-To Geek on MSN

How to pick a random name from a list in Excel

Select winners in Excel using classic INDEX formulas or modern CHOOSEROWS and TAKE combinations.
Geeky Gadgets

How to create Excel drop down lists for accurate and consistent spreadhseet data

When you work with Excel, you often need to ensure that the data entered into your spreadsheets is accurate and consistent. One effective way to achieve this is by using a drop-down list. In this ...