Scroll through the list of controls and look what’s available. Go to the developer tab and select Insert, followed by the little Pink Floyd-esque More Controls icon. Now you have the developer tab with all the controls for forms, xml, code, etc. Check the box for “ Show Developer Tab in the Ribbon“.Another menu will open – Select Popular.With the Pearl menu open select Excel Options from the very bottom on the right.The Pearl is the ball in the top left corner that gives you the option to Print, Save, etc. Select the Pearl or “ Office Button” in Excel.The first thing you need to do is enable the Developer Tab in Excel. Would you like the easiest, cheesiest, sleaziest way to do this? Well then watch this: I assume you just want someone using the spreadsheet to be able to select a cell, have a calendar drop down and then populate the field with whatever date the person chooses. This seems like it would be so easy yet when you look around on-line the answers are all full of VBA scripts and custom code. I want to have a cell formated so that I can have a pull down menu of a calendar in which to choose the date.

I am sure that I saw a pull down menu in a worksheet cell. How do I insert a calendar as a way for a user to click on the cell have the date box open and choose the date that should be in the cell? Also where do I send the beer?

So you want to create a drop down calendar in Excel? Apart from sending alerts to Outlook from Excel (working on that article as well) this has been the most requested how-to as of late.

Creating a drop down calendar in excel