How to Make a Drop-Down List to Choose a Date in Excel. Microsoft Excel lets you create simple forms that your users can enter data. To save them time and make sure you get the information you ...

To ensure that a date column is used correctly, you can effectively insert a calendar in Excel, using an Excel date picker.

This tutorial shows the steps to use Automatic Data Type in Microsoft Excel. It allows you to insert details of cities, food items, music, animals, persons, etc, automatically.

Excel’s data validation feature is underused because many users don’t realize how versatile it is, especially where dates are concerned. Dates seem to complicate things, but only in your head!

Use Editing, Fill, Justify to add instructions to your Excel 2007 worksheets When you need to add instructions to an Excel 2007 worksheet, they usually look something like Figure A.