Insert a Mini Calendar

PrintableCal provides the ability to insert a mini calendar, either at the current edit location, or as part of a template that gets automatically generated.

To insert a mini calendar at the current edit location in Excel, Word, or PowerPoint, click the Mini Calendar button on the PrintableCal tab of the ribbon. Select which month should appear first, the dimensions (in number of months as columns x rows), the font size of the dates in the mini calendar, and the mini calendar flow direction. After configuring the mini calendar, click the Insert button to insert at the current edit location.

Many of the templates included with PrintableCal will automatically include a mini calendar. For example, when generating the Week Column template, you'll see a mini month calendar in the upper-right corner.

Similar to how Legends can be automatically inserted, you can also customize templates to include a mini calendar. Name the cell range where the mini calendar should appear MiniCalendar, and set the cell value to MiniCalendar(Columns=X,Rows=Y), where X is the desired number of columns and Y is the desired number of rows.

For example, to generate a mini calendar that contains a 3x4 month grid (12 months total), set the value to MiniCalendar(Columns=3,Rows=4). The mini calendar will be aligned within the named cell range based on the specified text alignment.

The MiniCalendar formula also supports a parameter for specifying the starting month offset from the starting date specified for the generated template. The parameter name is StartMonthOffset and should be followed by a number, which can be negative, positive, or 0. If this parameter isn't specified in the formula, a value of 0 is assumed as the default.

For example, to start the mini calendar on the previous month, with 4 months total, the formula would be MiniCalendar(Columns=4, Rows=1, StartMonthOffset=-1).