How to Make a Calendar Using Excel

There is a lot you can do with Excel, including making and editing your own custom calendars. This is possible in all versions of Excel, from the Microsoft 365 and Excel for the Web versions to older editions, like Excel 2010.

How to Make a Calendar Using Excel With Microsoft 365

If you’re using the Microsoft 365 version of Excel, making a calendar is quick and easy, as the app comes with plenty of pre-built calendar templates for you to choose between.

Step 1. Open Excel and press “File” and then “New.”

Step 2. Scroll down beyond the “Blank workbook” and other top options to find additional templates. The list should include various calendar templates. Find whichever one you’d like to use and click on it. Note that you can also type “calendar” into the search bar at the top of the templates menu to see all the calendar options.

Step 3. Click the “Create” button to open a new workbook with your chosen calendar template.

How to Make a Calendar Using Excel for the Web

On Excel for the Web, the process of making a calendar is very similar to making one on the Microsoft 365 version. You just need to find the calendar templates and select whichever one you want to use.

Step 1. Log in to your Microsoft 365 account in your browser of choice. Then select “Workbook” to start a new Excel workbook.

Step 2. Click “File” and then “New.” Then select “Browse templates.”

Step 3. Find any suitable calendar template in the list provided, hover over it, and then select “Create” to open it up.

Step 4. Your calendar will open as a new workbook, and you’ll be free to edit it as desired. You can add notes to individual dates or type in the boxes beneath them to make reminders of important meetings, appointments, and so on.

How to Make a Calendar Using Older Versions of Excel (2003, 2007, and 2010)

If you’re using an older version of Excel, you can still access and use calendar templates, though you may not have quite as many options or access to the same advanced features that are only present in newer editions of the software. The process for finding these templates is quite simple:

Step 1. Open Excel and click “File,” then “New.”

Step 2. Select the “Calendars” option to browse available templates. Choose whichever one you want to load it into a workbook, and then make any desired edits.

Note that you can also access this link to find a full library of Microsoft Office calendar templates. There are many options available, and you can use the search bar and filter options to find your favorites. Click on any template you like to either open it in Excel for the Web or to download a copy which you can then open in your desktop version of Excel.