Insert a Date At the Current Cell or Text Location

PrintableCal provides a mini calendar (or date picker) in Microsoft Word, Excel, and PowerPoint. A date in the mini calendar can be clicked to be inserted at the current cell (Excel) or text cursor location (Word and PowerPoint). 

To make the mini calendar visible, click the Date button on the PrintableCal tab of the ribbon.

To insert a date, click or double-click the desired date in the mini calendar. 

Settings

Date format The inserted date format can be adjusted to use the system default format, a short format, or a long format. Each format will depend upon the regional settings specified in the Windows Control Panel. For example, when Windows is configured to use the English (United States) regional format, the inserted dates will be formatted as shown below.

Date selection mode   Dates can be selected from the data picker by either single clicking or double clicking.
Active cell after inserting This setting is only available in Excel. It controls which cell becomes active after picking a date. Choices are Activate cell in next row, Activate cell in next column, or Do not change active cell.

blog comments powered by Disqus