How to Insert a Calendar When Clicking on a Cell in Excel

Microsoft Excel lets you create tables, spreadsheets and graphs that contain data of all types. One type of data that is commonly found in an Excel spreadsheet is calendar data, but it can be a pain to have to type dates over and over. One way to get around this issue is to insert a calendar drop-down menu into your cells so that you can pick the dates from the calendar rather than having to type them in. If you want to insert such a calendar into your spreadsheet, you can do so by enabling Developer Mode from the program's main menu.

Step 1

Click the "Office" button and select the "Excel Options" option from the drop-down menu that appears.

Step 2

Click the "Popular" tab in the "Options" menu and place a check mark next to the "Show Developer Tab in the Ribbon" option. Click "OK" to save the changes.

Step 3

Click the "Developer" tab, followed by the "Insert" menu. Select the "More Controls" button in the drop-down menu that appears.

Step 4

Highlight the "Microsoft Date and Time Picker Control" option, then click "OK."

Step 5

Click on the upper left corner of the cell to which you want to add the calendar and drag your mouse pointer to the cell's bottom-right corner. This will draw a rectangle around the cell.

Step 6

Release your mouse button to insert the calendar into the cell. Whenever you click on the cell, the calendar drop-down menu will appear.