How to Make a Blank Calendar in Excel (Download Free Template)

Get FREE Advanced Excel Exercises with Solutions!

If you are searching for quick steps or some special tricks to make a blank calendar in Excel, then you have landed in the right place. There are some quick steps to make a blank calendar in Excel. This article will show you every step with proper illustrations so you can easily apply them for your purpose. Let’s get into the central part of the article.

How to Make a Blank Calendar in Excel


Make a Blank Calendar in Excel: 5 Steps

In this section, I will show you some quick and easy steps to make a blank calendar in Excel on the Windows operating system. You will find detailed explanations with clear illustrations of each thing in this article. I have used Microsoft 365 version here. But you can use any other versions as of your availability. If anything in this article doesn’t work in your version, then leave us a comment.

📌 Step 1: Assign and Format Cells to Insert Month and Year

To create a calendar, the first thing you should mention is the month and year value, So, in a blank calendar, you have to assign someplace to locate the month name and year value. Here, I am showing you how to format and merge cells to locate month and year values in a calendar.

  • First, increase the row height where you want to place the month and year.
  • Click on the row and drag the plus icon to increase the row height.

Increase row height in Excel

  • Alternatively, you can also change the height from the Format option in the top ribbon.
  • For this, go to the Home tab >> Format >> Row Height

Change row height from format option

  • Then, a new pop-up window named Row height will appear.
  • Insert the row height that you want to apply for the row.
  • And, then press OK.

row height window

  • Now, merge the cell range A1:F1 to assign the merged cell for a month and cell range G1:N1 for a year.

Merge cells to create one large cell

  • Then, choose a fill color for the month and year cell to look more interactive. For this, select the merged cell and go to the Home tab in the top ribbon.
  • Then, click on the Fill Color icon and select a color from the list set as the fill color of the Month.

Setting fill color

  • Then, you have to apply a border to the Month. For this, select the cell and go to the Home tab.
  • Click on the Border icon and select any from the list.

Setting border type for cells in Excel

  • Similarly, you have to create and format the location for the Year value.

📌 Step 2: Assign Cells to Show Name of WeekDays

Then, create and assign cells to show the names of the weekdays. Here, I will take 2 rows for each weekday, so I have to merge every two cells first and then insert the name of the weekday.

  • First, merge every two cells respectively to insert the name of the weekday.
  • Then, insert the name of the weekdays starting from any day that you wish.

inserting weekdays while making a blank calendar

  • Then, format the cells showing the weekdays.
  • First, choose a fill color for the weekdays and apply a border for all sides of the cell.

formatting weekdays cells


📌 Step 3: Assign Days of Months and Format the Cells

After creating weekdays, you have to create month dates from 1 to 30/31 or any others. Here, I will take 5 rows for each day so 1 row will contain the date number, and the remaining 4 rows can be used for listing daily tasks or important notes.

  • For this, select the cell range B5:C9 and go to the Home tab.
  • Click on the Border icon and select the Outside Border option to separate each day in the monthly calendar.

setting borders for each days in Excel blank calendar

  • Then, to separate the day number and tasks, you should border the cell which will contain the day number of the month.
  • So, select cell B5 and apply a thick outside border to it.

Month day cell of blank calendar in Excel

  • Now select the previous cell range again.
  • And, click on the right-bottom corner of the selected range and thus the cursor will be converted to a plus icon. This is called the Fill handle icon.
  • Now, drag the Fill Handle icon to paste the similar borders to the cells till column O.

Dragging fill handle to apply same formatting

  • Then, select the cell from B5:O9 and drag the fill handle till cell O29.

  • As a result, you have created a blank calendar of a month.

Read More: How to Create a Monthly Calendar in Excel


📌 Step 4: Change Column Width of the Calendar

Now, you can change the column width as small width is required for the 1st column of each date. Because you will insert the date number in the 1st column and the task in the 2nd column. So, 2nd column will need wider space. For this, you should shorten the 1st column width and enlarge the 2nd column with each cell.

  • For this, select the columns D, F, H, J, L, and N and go to the Home tab in the top ribbon.
  • Here, click on the Format button and select the Column Width option from the list.

Increasing column height for columns of blank calendar in Excel

  • Then, the Column Width pop-up window will appear.
  • Here, insert 5 as the column width for the 1st columns as you want to shorten their width.
  • Then press OK.

Column Width

  • Similarly, select columns C, E, G, I, K, M, and O and set the column width as 15.

Ready Made Blank Calendar in Excel


📌 Step 5: Highlight the Holidays in Calendar

Just one more this remaining for the blank calendar and that is to highlight the weekend days. For this,

  • Select the cells of range L5:O29.
  • Go to the Home tab and click on the Fill Color
  • Select a Fill color to highlight the cells.

applying fill color to highlight weekends

  • Now, the blank calendar is ready and you can edit this for your purposes.

Blank Calendar in Excel with highlighted holidays


✅ How to Use This Calendar:

  • First, insert the month and year values in the assigned section.
  • Then, insert the day number according to the first weekday of the month.
  • Then, you can add any tasks, plans, or reminders to the blank cells of each date.

A Blank Weekly Calendar To-Do List in Excel

Similarly, you can also create a template to create a personalized weekly calendar in Excel or a to-do list where you can plan your tasks for a week. Here, I have created a Blank weekly calendar and am sharing the workbook with this article. So, you can download this file and use this as your weekly To-do list calendar.

Create Blank Weekly Calendar To-Do List in Excel


How to Create Interactive Calendar from Excel Templates

In Microsoft Excel 365 or some older versions, you will find some free templates to create an interactive calendar. Many Excel developers have already created those templates and shared them with us to use for free. To use those free templates, follow the steps below:

📌 Steps:

  • Open a blank workbook in Microsoft Excel and go to the File tab.
  • Then, click on the New option.
  • Here, write Calendar in the search box and click on the Search icon.

Search Calendar templates

  • Then, you will see some calendar templates shown in the list.
  • Select any of them from the list.

Free Calendar templates in Excel

  • After selecting, you will see a new workbook will open which contains the calendar template.
  • Here, I have selected a template where you have to insert the year value in cell K5 and starting weekday in cell L5. Thus, the whole workbook will automatically be updated and the calendar of each month will be displayed in different worksheets of the workbook.

Interactive Calendar from Excel Templates


Download Blank Calendar Template

You can download the practice workbook from here:


Conclusion

In this article, you have learned how to make a blank calendar in Excel. I hope you found this article helpful. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Article

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Osman Goni Ridwan
Osman Goni Ridwan

OSMAN GONI RIDWAN is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, OSMAN has transitioned into the role of a content developer. Specializing in creating technical content exclusively centered around Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo