How to Make A Calendar In Excel

Create a calendar for the week, month, or year

There are often times when you need a calendar, and you may not have the time to go out and buy one. Or maybe you only want a single month to pin up to your wall.

The good news is that it's very easy to create a calendar in Excel. Just follow the steps below and you can print your new calendar in just a few simple steps.

This article applies to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel for Mac, Excel for Android, and Excel Online.

Make a Pre-Made Calendar in Excel

You can certainly craft your own calendar in Excel from scratch, but the easiest way to create a calendar is using a pre-made calendar template.

To create a calendar using this approach is very simple.

  1. Open Excel, select File and then select New. In the search field, type calendar and select the magnifying glass to initiate the search.

    Screenshot of searching for a calendar in Excel
  2. Select the calendar style that suites your needs. This example uses the Any year calendar. Once you've selected your calendar, select the Create button.

    Screenshot of selecting a calendar template in Excel
  3. Each calendar template has unique features. The Any year calendar template in particular lets you type in a new year or starting day of the week to automatically customize the calendar.

    Screenshot of using a calendar template in Excel
  4. Many of the templates have a different month per tab since each month has a different number of days, and a different starting day. Templates are useful because you can edit each day to include your own special events, and then print each month whenever you like.

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.

  1. Open Excel and type the days of the week in the first row of the spreadsheet. This row will form the foundation of your calendar.

    Screenshot of filling out days of the week in the Excel calendar
  2. Seven months of the year have 31 days, so the first stage of this process is creating the month for your calendar that can hold 31 days. This will be a grid of seven columns and five rows.

    To start with, 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.

    Screenshot of adjusting calendar columns in Excel
  3. Next, adjust the row heights by selecting the five rows under your weekday row, and adjust the height of the first column. With all five rows highlighted, all rows will adjust to the same height.

    Screenshot of adjusting row heights of a calendar in Excel
  4. Next, you need to align the day numbers to the upper-right of each daily box. Just highlight every cell across all seven columns and five rows. Right click on one of the cells and select Format Cells. Under the Text alignment section, set Horizontal to Right (Indent), and set Vertical to Top.

    Screenshot of adjusting alignment for daily calendar cells
  5. Now that the cell alignments are ready, it's time to number the days. You'll need to know which day is the first day of January for the current year, so Google "January" followed by the year you're making the calendar for. Find a calendar example for January. For 2019, for example, the first day of the month starts on a Tuesday.

    For 2019, starting from Tuesday, type from 1 to 31 from Monday through Friday each week.

    Screenshot of numbering the days of the month in Excel
  6. Now that you have January finished, it's time to create the rest of the months. Copy the January sheet to create the next month sheet.

    Right-click the sheet name and select Rename. Name it January. Again, right-click the sheet and select Move or Copy. Select Create a copy. Under Before sheet, and select (move to end). Select OK to create the new sheet.

    Screenshot of copying a month sheet in Excel
  7. Rename this sheet as the next month with 31 days; March. Right click the sheet, select Rename, and type February.

    Screenshot of adding the next month to the Excel calendar
  8. Repeat the above process for the remaining 10 months.

    Screenshot of adding all months to Excel calendar
  9. Now it's time to number all of the days of each month. Check the last day of the previous month, and continue the numbering of the next month from the next day of the week, starting with the number one. If the 31st of January is Wednesday, click on the next sheet for February and start the numbering from one on Thursday.

    Screenshot of numbering days for February in Excel
  10. Work your way through the rest of the months, giving 31 days to January, March, May, July, August, October, and December. The rest except February have 30. Number February with 28 days.

  11. As the last step, you can label each month by adding a row at the top and label it with the month. Insert a top row by right-clicking the top row and selecting Insert. Select all seven cells above the days of the week, select the Home menu, and select Merge & Center from the ribbon. Type the month name into the single cell, and reformat the font size to 16.

    Screenshot of the month of January with the month label
  12. Repeat the process for all 12 months.

Once you're finished numbering all months, you have a calendar in Excel for the entire year.

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 enable Gridlines under the Print section.

Screenshot of printing a monthly calendar sheet

Select OK and then Print to send your monthly calendar sheet to the printer.

Make a Custom Weekly Calendar in Excel

Another great way to stay organized is to break your schedule down to a weekly level hour-by-hour.

Excel is great for setting up such a weekly schedule. Creating a weekly calendar is very easy.

  1. Open a blank Excel sheet and create the header row by starting at the morning hour when you start your day in the first cell. Then work your way across the header row, keeping the first column blank, by every hour until you go to bed. Bold the whole row when you're done.

    Screenshot of creating an hourly header row in Excel
  2. Type out the days of the week in the left column, leaving the first row blank. Bold the whole column when you're done.

    Screenshot of creating a daily column in Excel
  3. Highlight all rows that include the days of the week. Once all are highlighted, resize one row to a size that will allow you to write in your daily agenda.

    Screenshot of resizing rows in the daily agenda
  4. Highlight all columns that include the hours of each day. Once all are highlighted, resize one column to a size that will allow you to write in your daily agenda.

    Screenshot of resizing the columns in the daily agenda
  5. To print your new daily agenda, highlight all cells of the agenda. Click File > Print. Change orientation to Landscape. Select Page Setup, select the Sheet tab, and enable Gridlines under the Print section. Change Scaling to Fit All Columns on One Page. This will fit the daily agend to one page. If your printer can support it, change the page size to Tabloid (11" x 17").

    Screenshot of printing out the daily agenda in Excel
  6. Having a printed daily agenda is a great way to keep your day organized on an hourly basis.

Make a Custom Yearly Calendar in Excel

If you're okay with a daily block to write in rather than an hourly one, a yearly calendar is more than enough for you to stay on task all year.

  1. Open a blank Excel sheet and create the header row by starting at January in the first cell. Then work your way across the header row, keeping the first column blank, typing in January through December. Bold the whole row when you're done.

    Screenshot of building the monthly row in Excel
  2. Type out the days of the month (up to 31) in the left column, leaving the first row blank. Bold the whole column when you're done.

    Screenshot of adding monthly days in Excel
  3. Highlight all rows that include the days of the month. Once all are highlighted, resize one row to a size that will allow you to write in your monthly agenda.

    Screenshot of resizing daily rows in Excel
  4. Highlight all columns that include the months of the year. Once all are highlighted, resize one column to a size that will allow you to write in your monthly agenda.

    Screenshot of resizing monthly columns in Excel
  5. To print your new yearly agenda, highlight all cells of the agenda. Click File > Print. Change orientation to Landscape. Select Page Setup, select the Sheet tab, and enable Gridlines under the Print section. Change Scaling to Fit All Columns on One Page. This will fit the yearly agend to one page.

    Screenshot of printing the yearly agenda in Excel
  6. Your yearly calendar will print one page wide and multiple pages long. You can paste these sheets onto your desk or wall and use it to keep track of your daily tasks.

Creating Your Own Calendar in Excel

The type of calendar you create really depends on how you plan and organize your days. For many people, a single block for each day is more than enough to track your events and tasks. For other people, an hourly schedule provides a better breakdown for a daily schedule.

Whichever option you go with, you'll know that you can always recreate and reprint your own self-made calendar any time you like.