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