Click the Linked Cell property and change it to the address of the cell you want linked to the control.(The Developer tab of the ribbon should still be visible.) Excel displays the Properties dialog box for the control. Click the Properties tool in the Controls group.When you release the mouse button, the control appears on the screen. Click at the upper-left of where you want the control to appear and drag the mouse to the lower-right corner.The dialog box closes, and the mouse pointer becomes a crosshair. Scroll through the list of available controls and choose Microsoft Date and Time Picker Control.Excel displays the More Controls dialog box. Click the More Controls option, which is the control at the very bottom-right of the options, under ActiveX Controls.Excel displays a palette of different controls you can insert.
Click the Insert tool, in the Controls group.Display the Developer tab of the ribbon.(I really wouldn't try this in a later version of Excel you more than likely won't be happy with the results.) (Why? Only Microsoft knows, and they are not saying.)Įven so, here's how you can insert the built-in calendar control, in this case in an Excel 2010 worksheet. Backwards compatibility between versions may be questionable, as well. In other words, you may implement the control in Excel 2007, but that same control may not work properly in Excel 2010 or later versions. Fortunately, there are a couple of ways you can implement calendars.Įxcel includes a built-in calendar control, but you need to be aware that the support for the calendar control has been a bit spotty between versions. Bruce would like to know if there is a simple way of inserting a standard calendar into a spreadsheet so that dates can be easily selected.