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).

Have questions about PrintableCal?

If this documentation doesn't answer your questions, please contact us. We'd be happy to help! You can send your question by entering it below. We'll respond as soon as we can, and always within 1 business day.

Don't have PrintableCal yet?

Installation of PrintableCal is quick and easy. All you need is a Windows computer with Excel, Word, or PowerPoint. Click the button below to start the download. You don't need to sign up for anything or provide an email address - simply download and run the installer. You'll be creating printable calendars in no time.

Runs on Windows 10, 8, and 7. Requires Excel, Word, or PowerPoint (Office 365, Office 2007 or later).
Compatible with both 32-bit and 64-bit versions of Office.