When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number ...

A common use of data validation is to create a drop-down list. Use it to restrict the type of data that users enter into an Excel cell.

Prevent duplicates before they happen by combining a simple function with data validation.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.