How to make a calendar in Excel

Contents
  1. Create a calendar for week, month or year
  2. Create a ready-made calendar in Excel
  3. Create your own monthly calendar in Excel
  4. Create your own weekly calendar in Excel
  5. Create your own annual calendar in Excel
  6. Create your own calendar in Excel

Create a calendar for week, month or year

Often you need a calendar and you may not have time to buy one. Or maybe you want it to be pinned to your wall for a month.

The good news is that creating a calendar in Excel is very easy. Just follow the steps below and you can print your new calendar in just a few easy steps.

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

Create a ready-made calendar in Excel

Of course, you can create your own calendar in Excel from scratch, but the easiest way to create a calendar is to use a pre-made calendar template.

Creating a calendar with this approach is very simple.

  1. Open excel select File and then select New † Type in the search field calendar and select a magnifying glass to start searching.

  2. Choose a calendar style that suits your needs. Using this example Calendar of each year † With the calendar selected, click the button To create

  3. Each calendar template has unique characteristics. especially the pattern Calendar of each year allows you to enter a new year or start day of the week for automatic calendar adjustment.

  4. Many templates have different months for each tab because each month has a different number of days and a different start day. The templates are useful because you can edit each day to include your own special events and then print each month whenever you want.

Create your own monthly calendar in Excel

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

  1. Open excel and enter the days of the week in the first row of the table. This row will become the foundation of your calendar.

  2. Seven months of the year have 31 days, so the first step in this process is to create a month for your calendar that can have 31 days. This will be a grid of seven columns and five rows.

    To start, select all seven columns and adjust the width of the first column to the size of the calendar day. All seven columns are configured the same.

  3. Then adjust the height of the rows by selecting the five rows below the day of the week row and adjust the height of the first column. When all five lines are selected, all lines are leveled.

  4. Next, you need to align the day numbers in the top right corner of each day block. Just select every cell in all seven columns and five rows. Right click on one of the cells and select Cell format † In section Text alignment install for Horizontal meaning Right (Indent) and for vertical Upwards.

  5. Now that the cells are ready, it’s time to count the number of days. You need to know which day is the first day of January of the current year, so on Google, “January” follows the year you’re creating the calendar for. Find a sample calendar for January. In 2019, for example, the first day of the month starts on Tuesday.

    For 2019, starting on Tuesday, enter 1 through 31 every week from Monday to Friday.

  6. Now that you’re done with January, it’s time to make the remaining months. Copy the January sheet to create the next month’s sheet.

    Right click on the sheet name and select rename † You name it January † Right-click the sheet again and select Move or copy † Select Make a copy † In section For the sheet select (jump to the end) † Select Okay to create a new leaf.

  7. Rename this sheet to next month with 31 days; March. Right click on the sheet, select rename and type February

  8. Repeat the above procedure for the remaining 10 months.

  9. Now it’s time to count all the days of each month. Check the last day of the previous month and number the next month from the next day of the week, starting with number 1. If January 31 is a Wednesday, click on the next sheet for February and start numbering from one on Thursday .

  10. Work your way through the remaining months, with 31 days through January, March, May, July, August, October and December. The rest, except February, has 30. February number with 28 days.

  11. As a final step, you can label each month by adding a line at the top and labeling it with the month. Insert the top row by right clicking on the top row and Insert † Select all seven cells above the days of the week, select menu At home and select Confluence and Center on the tape. Enter the name of the month in a separate cell and format the font size to 16

  12. Repeat the process for all 12 months.

If you numbered all the months, you have an Excel calendar for the whole year.

You can print every month by selecting all calendar cells and choosing File seal † Change orientation to Landscape † Select Page Settings go to the tab Sheet and turn on grid lines in the “Print” section.

Select Okay and then seal to send the monthly calendar sheet to the printer.

Create your own weekly calendar in Excel

Another great way to stay organized is to break down your hourly schedule into weekly tiers.

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

  1. Open a blank Excel sheet and create a title bar that starts at the morning hour when you start your day in the first cell. Then go through the title bar, leaving the first column blank, every hour until you go to bed. Grease the entire row when you’re done.

  2. Enter the days of the week in the left column, leaving the first line blank. Select the entire column when you’re done.

  3. Select all lines that contain days of the week. Once everyone is marked, resize from one line to a size that allows you to write down your daily tasks.

  4. Select all columns containing the hours of each day. Once everyone is marked, resize one column to a size that allows you to write down your daily tasks.

  5. Select all calendar cells to print a new calendar. Click File seal † Change orientation to Landscape † Select Page Settings go to the tab Sheet and turn on grid lines in the “Print” section. Change zoom in Fit all columns on one page † This fits into the daily agenda on one page. If your printer supports it, change the page size to: Tabloid (11″x17″)

  6. Printing a daily agenda is a great way to organize your day on an hourly basis.

Create your own annual calendar in Excel

If you have no problem with a daily notepad instead of an hourly, an annual calendar is more than enough to keep you working all year round.

  1. Open a blank Excel sheet and create a title bar starting with January in the first cell. Then scroll through the title bar, leaving the first column blank, and type January through December. Grease the entire row when you’re done.

  2. Enter the days of the month (up to 31) in the left column, leaving the first line blank. Select the entire column when you’re done.

  3. Select all lines containing the days of the month. Once everyone is marked, change the size from one line to a size that you can write in your monthly calendar.

  4. Select all columns containing the months of the year. Once everyone is highlighted, resize one column to a size that fits your monthly plan.

  5. Select all calendar cells to print a new year calendar. Click File seal † Change orientation to Landscape † Select Page Settings go to the tab Sheet and turn on grid lines in the “Print” section. Change zoom in Fit all columns on one page † This fits in the annual agenda on one page.

  6. Your annual calendar will print one page wide and several pages long. You can stick these sheets on your desk or wall and use them to keep track of your daily tasks.

Create your own calendar in Excel

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

Whichever option you choose, you know you can always recreate and print your own calendar.

Leave a Reply

Your email address will not be published.