how to insert a drop down calendar in excel 2016 for mac

So, we have to customize it to give a better look. You can see our date picker control is not looking good here. Read More: How to Combine Date and Time in One Cell in Excel (4 Methods) It will show a “ Reference not valid” error if you do that. It means what type of control is implanted in this worksheet. When you insert the date picker control in the worksheet, you will see an EMBEDDED formula in the formula bar. Finally, click on the cell where you want to insert the date picker.Īs you can see, we have inserted a date picker control in the Cell.

Now, select Microsoft Date and Time Picker Control 6.0 (SP6) from the More Controls dialog box.

From the ActiveX Controls, click on the More Controls.

From the Controls tab, click on Insert.

It’s time to insert the date picker in the worksheet. Read More: How to Insert Day and Date in Excel (3 Ways)

From the right-hand side of the windows, select Main Tabs.Īs you can see from the Excel ribbon, we are successful in inserting the Developer tab in Microsoft Excel.

Now, from the Excel Options dialog box, click on Customize Ribbon option on the left side.

So, let’s enable the developer tab first. So, before you start, you have to enable the developer tab in Microsoft Excel. Enable Developer Tab in Excel for the Date Pickerįirst of all, this date picker tool is only available in the Developer tab. It will obviously develop your Excel knowledge.ġ. We recommend you closely look and learn all these steps. In the following sections, we will provide you with a step-by-step guide to inserting a date picker in Excel. Step by Step Guide to Insert Date Picker in Excel With this tool, you can choose any date and perform any operations in Microsoft Excel. It is a pop-up calendar that you can use to insert dates and control them. What if you have 500 rows in a dataset? You wouldn’t like to insert all the dates manually in Excel! How do we insert a date in a cell? By typing it in the cell, right? We all know typing is a hectic matter. Now, people love to work with user interfaces.

How to insert a drop down calendar in excel 2016 for mac