Need help in adding calendar drop down excel Mac

Asked By 30 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 10 points N/A #153906

Need help in adding calendar drop down excel Mac

qa-featured

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

Related Questions