No of visitors who read this post: 263
Category: Apple Software
Type: Question
Author: Mary West
No votes yet

I'm having a hard time using the later versions of Excel.  How can I create a drop down calendar menu in a spreadsheet?  There is a no "create list" in right click options.  I need help in adding calendar drop down excel Mac.  I use Excel 2012 on my iMac with 3.2 GHz Core i5 and OSx Mountain Lion.  Thanks.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

# Comment Id: 129917

Hi Mary West!

While using Excel 2012, it is possible to add calendar drop down list. This can be done by using the Data Validation tool. This tool enables you to control the data entered and it makes it simpler for users to enter the data. For more details on how to use the Data Validation tool, please visit this link: http://www.get-digital-help.com/2011/01/29/create-a-drop-down-calendar-in-excel/.