Calendar template

How to Make a Calendar in Excel

What there is to know

  • The easiest way is to use the many predefined calendar templates: go to Case > New > “calendar” in the search field > select calendar > Create.
  • You can also use Excel to create a custom calendar.

This article explains four different ways to create a calendar in Excel. Instructions apply to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel for Mac, Excel for Android, and Excel Online.



How to make a pre-made calendar in Excel

You can create your own calendar in Excel from scratch, but the easiest way to create a calendar is to use a predefined calendar template. Templates are useful because you can edit each day to include special events, then print each month whenever you want.


Tigerlily713/Pixabay

  1. Select Case > New.


  2. In the search field, type calendar and select the magnifying glass to start the search.


  3. Select the calendar style that meets your needs. This example uses the Calendar of any year. Once you have selected your calendar, select Create.


  4. Each calendar template has unique features. The Calendar of any year The particular template allows you to enter a new year or week start day to automatically customize the calendar.


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.


  1. Open Excel and type the days of the week in the first row of the worksheet. This line will form the basis of your calendar.


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

    To get started, select all seven columns and adjust the width of the first column to the size you want for your calendar days. All seven columns will adjust to the same.


  3. 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, simply highlight the rows you want to adjust before changing the height.


  4. Next, you need to line up the day numbers at the top right of each day box. Highlight each cell in all seven columns and five rows. Right click on one of the cells and select Format cells. Under the Text alignment section, whole Horizontal at Right (indent)And put Vertical at High.


  5. Now that the cell alignments are ready, it’s time to number the days. You’ll need to know what day is the first day of January for the current year, so Google “January” followed by the year you’re creating the calendar for. Find a sample calendar for January. For 2020, for example, the first day of the month starts on a Wednesday.

    For 2020, starting Wednesday, number the dates in sequential order until you get to 31.


  6. Now that January is over, it’s time to name and create the rest of the months. Copy the January sheet to create the February sheet.

    Right-click the sheet name and select Rename. Name it January. Again, right-click on the sheet and select Move or copy. Select Create a copy. Below front sheetselect (skip to end). Select OKAY to create the new sheet.


  7. Rename this sheet. Right click on the sheet, select Renameand type February.


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


  9. Now is the time to adjust the date numbers for each month after the January month pattern. Beginning in February, stagger the start date of the month on the day of the week following the last day of January. Do the same for the rest of the calendar year.

    Don’t forget to remove non-existing dates 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).


  10. As a final step, you can label each month by adding a line at the top of each sheet. Insert a top row by right-clicking the top row and selecting Insert. Select the seven cells above the days of the week, select the House menu, then select Merge and center ribbon. Type the name of the month in the single cell and reformat the font size to 16. Repeat the process for the rest of the calendar year.


Once you are done numbering the months, you will have an accurate calendar in Excel for the whole year.


You can print any month by selecting all calendar cells and selecting Case > To print. Change orientation to Countryside. Select Layoutselect the Sheet tab, then enable Grid under the Print section.


Select OKAY so what To print to send your monthly calendar sheet to the printer.



How to Create a Custom Weekly Calendar in Excel

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


  1. Open a blank Excel sheet and create the header row. Leaving the first column blank, add the time you usually start your day to the first row. Go through the header row adding an hour until your day is done. Bold the entire line when finished.


  2. Leaving the first row blank, type the days of the week in the first column. Bold the entire column when you’re done.


  3. Highlight all rows that include days of the week. Once everything is highlighted, resize a row to a size that will allow you to write in your daily/hourly planner.


  4. Highlight all columns that include times for each day. Once everything is highlighted, resize a column to a size that will allow you to write in your daily/hourly planner.


  5. To print your new daily planner, highlight all the cells in the planner. Select Case > To print. Change orientation to Countryside. Select Layoutselect the Sheet tab, then enable Grid under the Print section. Replace scale with Fit all columns on one page. This will fit the daily agenda to one page. If your printer can support it, change the page size to Tabloid (11″ x 17″).


How to Make a Custom Yearly Calendar in Excel

For some people, a yearly calendar is more than enough to stay focused year-round. This design is about the date and month, rather than the day of the week.


  1. Open a blank Excel sheet and, leaving the first column black, add January to the first row. Scan the header row to December. Bold the entire line when finished.


  2. Leaving the first row blank, type the days of the month in the first column. Bold the entire column when you’re done.

    Don’t forget to remove non-existing dates 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).


  3. Highlight all rows that include the days of the month. Once everything is highlighted, resize a row to a size that will allow you to write in your daily planner.


  4. Highlight all columns that include the months of the year. Once everything is highlighted, resize a column to a size that will allow you to write in your daily planner.


  5. To print your new yearly planner, highlight all the cells in the planner. Select Case > To print. Change orientation to Countryside. Select Layoutselect the Sheet tab, then enable Grid under the Print section. Replace scale with Fit all columns on one page. This will keep the agenda on one page.


FAQs

  • How to insert a calendar in Excel?

    To insert a calendar in Excel using a template, open Excel and select New > Calendar. Choose a calendar, preview it and select Create. You can also go to Case > Choice > Customize the ribbon > Developer (custom) > OKAY then select Insert > More control. Select Microsoft Date and Time Picker Control > OKAY. This will put a drop-down calendar in the cell.

  • How to create a chart in Excel?

    To create a chart in Excel, highlight the cells you want to graph, including Labels, Valuesand On your mind. Go to Insert > Graphics and choose the type of chart you want. Charts also have different styles. For example, if you choose Bar chart, you will have the choice between six. Select OKAY and the chart will appear in the cells you selected.

  • How to create a drop down list in Excel?

    To create a drop-down list in Excel, open two blank worksheets. One will contain your drop down list data and the other will contain the drop down list. Enter your data, then enter the subject to which the list applies in the document from the drop-down list. To link them, create two named ranges (one for the list items and one in the workbook where the list is located).