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


Download Blank Calendar Template

You can download the practice workbook from here:


Steps to Make a Blank Calendar in Excel

In this section, I will show you some quick and easy steps to make a blank calendar in Excel on 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 of 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.

Read More: How to Create a Yearly Calendar in Excel (with Easy Steps)


📌 Step 2: Assign Cells to Show Name of WeekDays

Then, create and assign cells to show the name 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

Read More: How to Create a Weekly Calendar in Excel (3 Suitable Ways)


📌 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 respectively 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 (3 Effective Ways)


📌 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 column width as 15 to them.

Ready Made Blank Calendar in Excel

Read More: How to Make a Calendar in Excel Without Template (2 Examples)


📌 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

Read More: How to Make a Vacation Calendar in Excel (with Detailed Steps)


✅ How to Use This Calendar:

  • First, insert the month and year value in the assigned
  • Then, insert the day number according to the first weekday of the month.
  • Then, you can add any tasks or 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 or 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

Read More: Weekly Meal Planner Template with Snacks (Free Download)


How to Create Interactive Calendar from Excel Templates

In Microsoft Excel 365 or some older versions also, 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


Conclusion

In this article, you have found how to make a blank calendar in Excel. I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Article

Osman Goni Ridwan
Osman Goni Ridwan

I am Ridwan, graduated from Naval Architecture and Marine Engineering Dept, BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands. My prime goal is to be a data analyst as I do love to solve problems and play with data.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo