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.
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.
- 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
- 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.
- Now, merge the cell range A1:F1 to assign the merged cell for a month and cell range G1:N1 for a year.
- 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
- 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.
- 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 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.
- 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.
📌 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.
- 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.
- 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.
- 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.
📌 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.
- 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.
- Similarly, select columns C, E, G, I, K, M, and O and set column width as 15 to them.
📌 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.
- Now, the blank calendar is ready and you can edit this for your purposes.
✅ 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.
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:
- 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.
- Then, you will see some calendar templates shown in the list.
- Select any of them from the list.
- 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.
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.