Date Picker Option Missing On Microsoft Word 2016

Posted on |

Have you ever wanted a calendar to show next years date? It’s easy and convenient in most of the cases.

It can be a headache to maintain the data integrity when you are working with bigger and shared Excel worksheets. Especially, entering dates can become a nasty work. It always confuses the people if they should be mm/dd/yy or dd/mm/yy or mm-dd-yyyy? Or can you type a date like “10 Oct 2018”? Oh, and what would be the date of the third Friday in October this year?

May 21, 2017 2010-2016: Click on File, click on Options, click the Add-ins tab. In the Manage drop-down, choose Excel Add-ins, and click Go. Use 'Browse' to select the add-in and then click on OK. Verify that the Date Picker is checked in the add-in list and then click OK.

  1. A Date Picker In Microsoft Word.
  2. The picker button is activated automatically when you click a cell that is formatted as date, contains a date value or underneath the text 'Date'. This app requires the desktop version of Microsoft Excel 2016 / 2019. It does not work with the web version of Office (i.e. Office online that runs inside a web browser).

Adding a drop down calendar in your excel sheet can solve these problems. A drop down calendar allows your users to fill the dates on a click of mouse. This guide shows you a trick that might work for you and save you tons of your time.

Date Picker Option Missing On Microsoft Word 2016 Online

Before we start, you have to make sure the developer tab is available. If the developer tab is not already available in your Excel ribbons, you can follow these steps.

The first thing you need to do is click on the file in the top left of your screen and select “Options” at the very bottom of it.

This opens a new “Excel Options” box with bunch of options to select. Now click on “Customize Ribbon” which will bring out some more settings.

You should check the “Developer” option in the right hand box, under main tabs.

TADA! Now you have developer tab in your Excel ribbons. This is where all the magic is going to happen.

Now that you have the developer tab, let’s jump right into creating calendar and using it as a date picker.

Date Picker Option Missing On Microsoft Word 2016

In the developer tab, click on insert and go to the very bottom, where it says more controls. More controls allow you to insert a control from the set of controls available on your computer. The control we are going to use is available by default.

Once you click the more controls it open a new box with a list of options. In the list, scroll down the Microsoft date and time picker and select it.

Now you need to place the calendar somewhere on the screen. So select some part on your excel sheet and place it.
In the next step, turn off the design mode under developer tab. Now when you click on the little arrow it will bring out the calendar.

Date Picker Option Missing On Microsoft Word 2016 File

If you want to use calendar as a date picker you need to take a few more steps. Don’t worry we are almost there.

Now, turn back the design mode on again and click properties under developer tab. Under the properties click on LinkedCell and enter the cell number of your date. In my case which is B2.

Date Picker Option Missing On Microsoft Word 2016 Download And Install

Once you have assigned the date cell, turn off the design mode off again.
Now when as you pick the date from calendar it changes the date in your assigned cell.

This way you can share your excel sheet with other users and they can pick a date from calendar to fill the dates.

Date Picker Option Missing On Microsoft Word 2016 Download

In this article, I am going to show you how to choose Text Box and add Date or time in Microsoft office word 2016. Choosing Text Box in your document helps you. To Insert some vital information about a specific part of your report. By inserting this information, you can focus on that part of your document. Adding these kinds of Text boxes often used in a newspaper or magazines. For getting attention on important news. The position of the Text box can be everywhere, and you can put it according to the need of your document. Then insert your essential message within the Box. Here First, you can use some ready Text boxes, or you can draw a new one in your document. Then save that one in Text Box Gallery. Now at first, I am explaining choosing Text box later Adding date or time.

#1. Choose Text Box – the Ready Boxes

First of all, to a select Text box, we are going to Insert tab on Text group. Through this group, we have seven options which are depended on your Text in your documents. I will explain each of them, but now in Textboxes, we have some ready ones that have the deferent design for deferent positions in your documents. To select them, click on them and determine the location and sizes? Then insert your text.

Ready Tex Box

#2. Draw a Text Box Anywhere in Your Word Document

Date picker option missing on microsoft word 2016 download and install

Here in this step, you don’t have to use the Text box, which is already created by Microsoft Company. But you can make and draw your Text box according to the size of your extra information. And it’s a great way to bring your favourite Text box anywhere of your document that you want. To create a new Text box go to Text box and select the second option and draw it anywhere of your document, then write your information.

Date Picker Option Missing On Microsoft Word 2016 Crack

#3. Add Date or Time In Your Word Document

Adding date or time in your document helps you to determine the specific time of creating that document. It may help you to save time creating the document. To the current time and date of creating your document just click on Date and Time. Then select Format of showing your date and time and your language than the type of your date according to your location. If you want to update the location just tick mark the update and click OK.

Conclusion

Inserting a Text box helps you to focus on a specific and important point of your document. Through to Text box, you can write and share a short message for your self or for those who use your documents. Adding time and date helps you to give a date for a part of your document if it’s a historical document. Not just historical documents but in every kind of document, you can use date or time that you need. Here I explained how to insert a Text box or add date and time in your documents. Thanks for being with us.