Need help in adding calendar drop down excel Mac

Asked By Mary West 30 points N/A Posted on - 02/20/2013

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.

• Status: Open
• Question Views: 1318
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Apple Software

Answered By Shipley Claraj 10 points N/A #153906

Need help in adding calendar drop down excel Mac

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/.

About Shipley Claraj

Questions
3

Answers
39

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 02/20/2013
• Question Category: Apple Software