How to Make a Pre-Made Calendar in Excel
You can craft your own calendar in Excel from scratch, but the easiest way to create a calendar is using a pre-made calendar template. Templates are useful because you can edit each day to include special events, and then print each month whenever you like.
How to Make a Custom Monthly Calendar in Excel
If you don’t like the limitations of a calendar template, you can create your own calendar from scratch in Excel. Once you’re finished numbering months, you will have an accurate calendar in Excel for the full year. To start, select all seven columns, and adjust the first column width to the size you’d like your calendar days to be. All seven columns will adjust to the same. For 2020, starting on Wednesday, number the dates in sequential order until you get to 31. Right-click the sheet name and select Rename. Name it January. Once again, right-click the sheet and select Move or Copy. Select Create a copy. Under Before sheet, select (move to end). Select OK to create the new sheet. You can print any month by selecting all of the calendar cells and selecting File > Print. Change orientation to Landscape. Select Page Setup, select the Sheet tab, and then enable Gridlines under the Print section. Select OK and then Print to send your monthly calendar sheet to the printer.
How to Make a Custom Weekly Calendar in Excel
Another great way to stay organized is to create a weekly calendar with hour-by-hour blocks. You can create full a 24-hour calendar or limit it to a typical work schedule.
How to Make a Custom Yearly Calendar in Excel
For some people, a yearly calendar is more than enough for you to stay on task all year. This design concerns the date and month, rather than the day of the week.
