How to create a calendar in Excel

It’s easy to create a calendar in Excel. Just follow the steps below and you’ll be sharing, printing or viewing a brand new personalized calendar in no time.

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

You can create your own calendar from scratch in Excel, but the easiest way to create a calendar is to use 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.

  • Open ExcelChoose dossier > art nouveau. Type in the search box calendar and select the magnifying glass to start the search.
  • Choose the calendar style that suits you. This example uses the annual calendar. After choosing your calendar, select Create.
  • Each calendar template has unique features. The website annual calendar you can enter a new year or start day of the week to automatically adjust the calendar.

If you don’t like the limitations of a calendar template, you can create your own calendar from scratch in Excel.

  • Open Excel and enter the days of the week in the first row of the worksheet. This line forms the basis of your calendar.
  • Seven months of the year have 31 days. So the first step in this process is to create the months in your calendar that have 31 days. This will be a grid of seven columns and five rows.

    First select all seven columns and adjust the width of the first column to the desired size of your calendar days. The seven columns all fit the same size.

  • Next, adjust the row height by selecting the five rows below your weekday row. Adjust the height of the first column.

    To adjust the height of multiple rows at once, just highlight the rows you want to adjust before changing the height.

  • Next you need to align the day numbers at the top right of each day field. Highlight every cell in all seven columns and five rows. Right click on one of the cells and select it format cells. As part of the text alignment section, ensemble Horizontal at right (dash)and fix Vertical at above.
  • Now that the cell alignments are done, it’s time to start counting the days. You need to know what day is the first day of January of the current year, so google “January” followed by the year you are making the calendar for. Find a sample calendar for the month of January. For example, for 2020, the first day of the month begins on a Wednesday.

    For 2020, starting Wednesday, number the dates consecutively through March 31.

  • Now that you’ve completed the month of January, it’s time to name and create the remaining months. Duplicate the January sheet to create the February sheet.

    Right-click the sheet name and select Rename. name it January. Right-click the sheet again and select it Move or copy. Choose Make a copy. sous In front of the plugChoose (jump to end). Choose OK to create the new record.

  • Rename this sheet. Right click on the sheet, select it Rename and type February.
  • Repeat the above process for the remaining 10 months.
  • Now it’s time to adjust the date numbers for each month after the January model month. Start in February and move the start date of the month to the day of the week after the last day of January. Do the same for the rest of the calendar year.

    Remember to remove nonexistent data from months that are not 31 days. These include February (28 days – 29 days in a leap year), April, June, September and November (30 days).

  • Finally, you can label each month by adding a line at the top of each sheet. Insert a row at the top by right-clicking the top row and selecting insertion. Select the seven cells above the days of the week, select those Warm welcome and then select Merge and center Ribbon. Enter the name of the month in the single cell and reformat the font size 16. Repeat the process for the rest of the calendar year.

Once you’re done counting the months, you’ll have an accurate calendar in Excel for the entire year.

You can print each month by selecting and choosing all calendar cells dossier > to print. Changer d’orientation pour landscape. Choose layout choose Form then activate the tab grid lines suppress”.

Choose OK and then to print to send your monthly calendar sheet to the printer.

Another way to stay organized is to create a weekly schedule with hourly blocks. You can create a full 24-hour schedule or limit it to a typical work schedule.

  • Open a blank Excel sheet and create the header. Leave the first column blank and in the first row add the time you usually start your day. Go through the header and add the time until your day is over. Grease the entire line when you’re done.
  • Leave the first row blank and enter the days of the week in the first column. When you’re done, make the entire column bold.
  • Highlight all rows that contain days of the week. Once they’re all highlighted, resize one line so it’s big enough to write your daily/hourly planner.
  • Highlight all columns that contain times for each day. Once they are all highlighted, resize a column to a size that will allow you to write in your daily/hourly planner.
  • To print your new daily planner, select all cells in the planner. Choose dossier > to print. Change orientation to landscape. Choose layout choose Form then activate the tab grid lines suppress”. Change the scale up Fit all columns on one page. This allows the daily planner to fit on one page. If your printer supports it, change the page size to Tabloid (11″ x 17″).

For some people, an annual calendar is more than enough to keep you busy all year round. This design is more about the date and month than the day of the week.

  • Open a blank Excel sheet, leave the first column black, and insert “January” in the first row. Scroll down the header until you get to December. When you’re done, make the entire line bold.
  • Leave the first row blank and enter the days of the month in the first column. When you’re done, make the entire column bold.

    Remember to remove nonexistent data from months that are not 31 days. These include February (28 days – 29 days in a leap year), April, June, September and November (30 days).

  • Highlight all rows that contain the days of the month. Once they are all highlighted, resize a row to a size that will allow you to write in your daily planner.
  • Highlight all columns that contain the months of the year. Once they are all highlighted, resize a column to a size that will allow you to write in your daily planner.
  • To print your new year planner, select all cells in the planner. Choose dossier > to print. Change orientation to landscape. Choose layout choose Form then activate the tab grid lines suppress”. Change the scale up Fit all columns on one page. This allows the agenda to fit on a single page.
  Use Excel's MEDIAN function to find the average value