In our example, we select the Move but don’t size with cells radio button. In the Format Control window that opens, you have options to change the size, protect it, or edit alt texts. Right-click on the date-picker, a new menu will open. You’ll now see that the date picker has been inserted into your spreadsheet. Select Microsoft Date and Time Picker Control 6.0 (SP6). Step #4: Select Microsoft Date and Time Picker Control 6.0 (SP6) TIP: Hover with your mouse over each icon to see its name. Under ActiveX Controls, click on the More Controls icon, which looks like a spanner. Go to the Developer tab on the main menu.Ĭlick on the Insert icon, which will open a dropdown menu. The Developer tab will be added to your toolbar. Under the Main Tabs, tick the Developer checkbox. The Customize the Ribbon dialog box will open. Right-click on any empty space in the toolbar. Otherwise, click on Blank workbook to create a new workbook.
If you already have an existing workbook where you want a date picker, open that. If you use a 64-bit version, skip to the next method. Most modern PCs run the 64-bit version, though. You can use this method only if you use a 32-bit version of Microsoft Excel. 2 Methods of inserting a Date Picker in Microsoft Excel:
0 kommentar(er)
