How to Make a Calendar in Excel 2013

In this HowTech written tutorial, we’re going to show you how to make a calendar in Excel.
Calendars can be very helpful for organization, time management, and keeping track of important dates. Sometimes it may be very appealing to print out your own, and customized to your liking.


The easiest way to create a calendar in Excel, without getting into any Visual Basic code or very tedious manual work, is to simply go ahead and search for a calendar template.

save  capture


After searching, it’s just a matter of finding the right template that appeals and works for you (keep in mind that all templates are extremely customizable and there is much room for personal touch). After finding one, click it and hit Create.

hit Create

If there is any unwanted text or elements, simply remove them. Go ahead and change the year to the current year.
You will notice that the days of the months change with the year (very hard to code in Visual Basic and a pain to do manually).

remove any unwanted text or elements

For more customization, you can highlight certain days, and even create a Legend on the side to define the colors to corresponding events.

more customization