The “ More Controls” dialog box is opened Scroll down and look for “ Microsoft Date and Time Picker Control 6.0 (SP6)” Click on “ More Controls” – the lowest right icon.Check the “ Develop” on the right under Main Tabs.Go to File Tab (or Ribbon icon for Excel 2007).In case it is not on your ribbon, follow the following steps First, you need to go to the Developer Tab. So I would like to share with you, just in case you need it. I asked that because I didn’t know its existence in Excel as it is so well hidden. UPDATE on 2: Don’t miss the video at the end of this post.ĭid you ever ask why Excel does not provide Dropdown Calendar for date selection? Like the one shown below: