We can illustrate this technique by adding such a validation data control to the Membership Number column as follows: Select all existing data cells in the column in question.

How is indirect function used in data validation? On the spreadsheet, select cell C3. On the Ribbon, click the Data tab, then click Data Validation. From the Allow drop-down list, choose List.

Excel's data validation feature is more versatile than you might think. Learn how to use literal values, input values, list values, and even formulas to restrict input date values using data ...

Use data validation Data validation is like setting the group rules for your Excel cells. It ensures that only the right kind of data gets in and eliminates any errors or typos.

If you regularly deal with enormous data sets in Excel, knowing how to use these features (some simple, others intricate) can help you manage your workload.

It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.