How to Create Calendar in Excel

This example describes how to create calendar in Excel. The calendar is an important part of keeping all your activities, appointments, meetings and events organized. You can do a lot with a calendar. People use them as a timesheet to make a work or school schedule to track a project and much more.

There are a couple different options to make a monthly or yearly calendar. You can create one from scratch using Excel, but that can be a time-consuming, manual task. You can also use a pre-built template of calendar in Excel, with the calendar already formatted for you. There a variety of pre-built calendar templates for Excel, ranging from 12-month calendars, monthly calendars, weekday displays, and calendars with notes.

Steps to create Calendar in Excel.

Write days in the cell

  1. Leave the first row in your spreadsheet blank. On the second row type the days of the week (one day per cell). In our example, we typed Monday in cell A2, then Tuesday in cell B2 and typed another day into rest of this row same as like above picture.
    Just type Monday in cell A2 then use fill handle of selected cell to drag on the right side of this cell

    Tips 1: Just type Monday in cell A2 then use fill handle of the selected cell to drag on the right side of this cell. It will automatically create Tuesday to Sunday in this same row as like above picture.

    How to create calendar in Excel using column width

  2. To format the weekday headers with ensure proper spacing, highlight the weekdays you just typed and click on Home tab, in the Cells group click Format.  Select Column Width and set the width to around 15, depending on how wide you want the calendar.How to insert current date in Excel
  3. In the first blank row 1, we want to add the current month as the Title of the calendar using a formula. Click any cell in the first row and in the fx field above the blank row, type this formula:

    This formula used to tells Excel show us today’s date in that field. After that the title of this calendar will be looked like 3/5/2017. But we need the Title as Month only.

    How to insert more number formats in Date

  4. Click the cell D1 with the date. Click Home tab, in the Number group, click the Date drop-down. Select More Number Formats to choose the format you would like for the month title.
    How to Format Cells in Excel
  5. Now Format Cells dialog box appears. Select Date format from type list. Click OK.
    How to use Merge and Centre in Excel
  6. Now We have got our Month title with exact format. Select range A1 to G1, Click Home tab and from the Alignment group click Merge and Center.
    How to use different types of date formatting
  7. Now Our month Title is looked like above picture (March-17).
    How to insert theme color in Excel
  8. Now we will create the body of our Calendar. We will use borders to create the date boxes. First, highlight your whole spreadsheet. Now, click the paint bucket icon on the Home tab and select white. Your spreadsheet should now have a white background.
    How to insert Outside Borders in Excel
  9. Highlight five cells under Monday. Click Borders icon in the Home tab and select the outside borders option to outline the first date box in the row.
    copy and paste it under the other weekday headers
  10. Now copy and paste it under the other weekday headers. This duplicates your box for the other days in the week. Do this for five total rows in your sheet as like above picture.How to insert All Borders in Excel
  11. Add borders around the weekday headers and highlight the row with the weekdays. click the borders icon, and choose the All borders.
    How to insert more borders in Excel
  12. We have created the framework for the calendar, now it’s time to add the dates. Here’s how:For each row in the calendar, enter the first two dates of that week in the first cells in each box. For example the 1st of this month March of 2017 is Wednesday, enter 1 into the first Wednesday box and 2 in the Thursday box. Now hold down Shift and highlight both cells with the numbers. See the above picture. Drag the bottom right corner of the highlighted cells to auto-fill the rest of the week. You must manually enter the first two dates for each row before you can drag and auto-fill the rest of the week.Repeat this for the whole month.
    Now our Monthly calendar is completed Successfully
  13. Now our Monthly calendar is completed Successfully.
    let’s Decorate Our calendar by coloring
  14. Now let’s Decorate Our calendar by coloring. Select Monday to Saturday and Fill the color with your choice. Now fill the color of Sunday as Red, because it is weekend.Now Select days under Sunday to change font color as Red
  15. Now Select days under Sunday to change font color as Red as like Above picture. Now our Calendar of Month March-2017 is completed successfully. Now you can add note also in each date if you want like meeting, schedule etc.
  16. Now copy this month from this Sheet1 to other sheets to create another 12 months. Now our calendar is created successfully.

By this process, you can create calendar in Excel with a different style

So, Now we have learned How to create Calendar in Excel! Enjoy Excel Tips!

If you wish to learn more about “How to” read below

  1. How to create Sparkline in Excel
  2. How to use histogram in excel
  3. How to unhide/hide rows & column in Excel
  4. How to wrap text in excel

Pre-Registration Open

Power BI Dax

Related Tutorials

Text To Column in Excel | Split Cells
January 4, 2019
Pivot Tables (Complete Guidelines)
December 27, 2018
Power Bi Dax Deduplication Based On Column
December 17, 2018
Special Character Symbol List with Shortcodes in Excel
December 15, 2018
December 10, 2018
December 10, 2018
How to use ABS Function in Excel
December 10, 2018
How to use AND Function in Excel
December 10, 2018
Delete Duplicate in Excel or Remove Duplicate in Excel
November 9, 2018
Excel Formulas PDF
September 6, 2018
How To Lock Cells in Excel | Unprotect Excel
August 13, 2018
4x Faster at Excel
August 6, 2018
Separate Content of One Excel Cells into Separate Columns
August 3, 2018
How to Transpose Excel Columns to Rows | Paste Special Method
July 26, 2018
How to create sparklines in Excel
July 19, 2018
AutoSum in Excel with Shortcut
July 17, 2018
OFFSET Function in Excel
July 6, 2018
Strikethrough Shortcut in Excel & Word
July 4, 2018
INDIRECT Function with SUM, MAX, MIN & Independent Cell Value
June 29, 2018
Pivot Table Slicers In Excel
June 12, 2018
How to Wrap Text in Excel Automatically and Manually
June 6, 2018
How to Hide/Unhide Column in Excel
June 5, 2018
Highlight row based on cell value
June 4, 2018
Learn how to remove blank cells in Excel
June 3, 2018
How to Group Numbers, Dates & Text in Pivot table in Excel
June 1, 2018