How-To Geek on MSN

3 must-know custom data validation formulas for preventing errors in Excel

Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...
TechRepublic

How to force a consistent phone number format in Microsoft Excel

How to force a consistent phone number format in Microsoft Excel Your email has been sent Combine an Excel custom format with data validation and remove the pressure ...
TechRepublic

How to run a VBA procedure from a data validation control in Microsoft Excel

How to run a VBA procedure from a data validation control in Microsoft Excel Your email has been sent There are lots of ways to execute a VBA procedure in Microsoft Excel. You can add macro buttons at ...
Computerworld

How (and why) to use conditional formatting in Excel

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 ...