Our lives have never been so busy before. We go to meetings, we work on projects, we try to meet deadlines at work, and besides that, we organize our personal lives, so it can be very difficult to keep everything under control.

Calendars are an important part of our lives, they help organize our activities, meetings, receptions and events. The calendar has huge potential: it is used as a time sheet, to create a school or work schedule, to track projects, etc.

You can create a calendar for a month or a year in several ways. You can create a calendar from scratch manually using Excel, but this can be a time consuming process. You can also use the built-in and pre-formatted calendar template in Excel. You can choose from enough a large number calendar templates, such as a 12-month calendar, a monthly calendar, a weekday-only calendar, or a calendar with notes. These templates have been pre-created and pre-formatted, you just need to populate them with your events.

But how to choose the easiest one to use from all this variety of templates in Excel? We looked through all the templates and found the best calendar templates in Excel - monthly and yearly.

Download Monthly or Yearly Calendar Template in Excel

smartsheet

How to Create a Monthly or Yearly Calendar Template in Excel

The calendar template is extremely easy to use. All you need to do is choose a calendar type (monthly or yearly) and add your own scheduled events to the template. You can also customize the font type, size, and color. If you choose a monthly calendar, you first need to change the name and dates for the month you want.

Here are some additional steps to customize the template for your needs:

1. Format the monthly calendar template

1. To change the name, double-click the name field, delete the formula, and then enter the new month in the cell.
2. You will then need to renumber the date cells. You can enter the dates manually or use the auto-fill feature, which we'll talk about in "How to Create a Monthly Calendar in Excel 2007 and 2010" (point 4).

2. Add events to the monthly or yearly calendar template

1. Whichever template you choose, double-click on a cell in the date window and enter an event. To enter multiple events for the same day, click on another cell in the date cell.
2. To place the text in the center, click on the cell. Then, in the “Home” tab, find the “Alignment” section, and then click on the “Align Center” icon (in the form of five lines of text in the center).

3. Change font and color

1. Click on the cell with the text you want to change and then go to the Home tab, where you can change the font type, size and color, use bold, apply italics or underline.
2. To change the background color of the heading with the names of the days or the added event, select the cell, click on the icon in the form of a bucket of paint and select a fill color.

You can also personalize the calendar template by adding a photo, such as your company logo. Open the "Insert" tab, click "Illustrations". Upload the required image. It will be added to your table and you can drag it to the right place.

How to create a monthly calendar in Excel 2007 or 2010

To create a monthly or yearly calendar in Excel, use the following instructions:

1. Adding headers with day names

First of all, you will need to add the days of the week as headings, as well as the name of the month.

1. Leave the first row of your table empty. In the next (second) line, enter the days of the week (one day for each cell).
2. To format headings with days of the week and make sure there are none extra spaces, select the days of the week you just entered, and on the Home tab, in the Cells section, select Format. Select "Column Width" and set the width to 15-12, depending on how wide you want your calendar to be.

2. Adding a calendar name

1. In the first empty line, we will indicate the current month as the name of the calendar. To do this, we use the formula. Click on the cell in the first row and in the field “ fx” above an empty line, enter the function =TODAY() . This way, Excel will know that you want to display the current date in this field.

1. Please note that the date format is incorrect. To correct this error, click on the cell with the date. In the “Home” tab, go to the “Number” section and select “Date” in the drop-down menu. Then select "Additional Date Format" and choose the required format.

To center the title, select all the cells in your title bar (including the cell with the month displayed) and go to the Home tab and click on the Merge and Center button.

The custom class log contains the same information as the standard class log, but allows you to customize the reports. That is, you can change the frequency class, note, or content log template templates. Before printing the class journal, the user had to complete: registration of steps, disciplines, curriculum and disciplines by the teacher, in addition to enrolling and enrolling students.

If you want to organize the class number of students, you must do so through the base module. To create new report templates, click the Layout button on the right side of the screen. Looks for a subclass: By checking this element, when a discipline has subclasses, the system will print a class diary of the class for each of the subclasses.

3. Create days in the calendar

Now let's start creating the main body of the calendar. We will use borders to create date cells.

1. First, select your entire spreadsheet.

1. Then click on the paint bucket icon in the Home tab and choose white color. Your spreadsheet should now have a white background.

1. Then select five or six cells located under the heading with the first day of the week. In our case, this is Monday.

1. While the cells are still selected, click on the border icon in the Home tab and select the appropriate cell border option. This way we will create a frame for the first date cell.
2. Select the newly created cell and copy it into the table under the rest of the headings with the days of the week. This will create copies of your cell for other days of the week.

Repeat these steps for all five rows of your table. Your calendar should now look like this:


The student's situation identification is printed in front of the student's name. Prints students with pending enrollment. Show enrollment date for students blocked, canceled, transferred, reassigned, fired, and written off: By checking this element, the system includes in the text that identifies the student's irregular situation, as well as identifying the student's enrollment date.

Adding a calendar title

The report can be ordered from This form is used to issue a call list according to the agency template. To do this, click the "Layout" button located on the right side of the screen and create a new layout. If you want to make changes, click the Layout button again to display the default template, which can be modified as needed. In the standard type, it has two different models for the front and back of the diary. In addition to the default fields, fields for class number or date are displayed.

To add borders around headings with days of the week, select the rows with the days of the week, click on the border icon and select all borders.

4. Adding dates

We have created the basic structure for the calendar, now let's start filling it with dates. You can enter dates manually for each cell, or you can use the automatic filling function that Excel has. Here's how to do it:

1. For each row in the calendar, enter the first two dates of the current week in the first two cells of each cell. For example, if the first of the month is Wednesday, enter 1 for the first Wednesday and 2 for Tuesday.

1. Then hold the "Shift" key and select both cells with numbers.

1. Drag and drop the bottom right edge of the selected cells to autofill the remaining cells of the week.
2. Repeat these steps for the entire month.

Note. The first two dates for each row must be manually entered before you can drag-and-drop and auto-populate all week cells.

How to create an annual calendar in Excel

Basically, you've just created a monthly calendar template. If you want to use the calendar only periodically for certain months, you can use the same calendar by simply changing the name of the month and changing the numbering of the days.

You can also use your monthly calendar structure to create a yearly calendar. For this:

1. At the bottom of the table right click mouse click on the “Sheet1” tab.
2. Click "Move or Copy".

1. Check the box next to the “Create a copy” option and click “OK”.

1. Make 12 copies, one copy for each month of the year.

Note. For months with 31 days, you will need to add an extra row to the calendar.

Once you have created 12 copies, you will need to open each one and change the name to the corresponding month. In addition, you will need to change the numbers for each month either by manually changing the dates or by using the auto-fill feature that we cover in "How to Create a Monthly Calendar in Excel 2007 and 2010" (point 4).

Personalizing Your Calendar in Excel

It's very easy to create custom settings for your monthly or yearly calendar in Excel. You can color-code certain calendar events, such as business meetings or birthdays, or change font sizes. You can even add your company logo to the calendar.

1. Font Formatting

1. To enlarge the title font, click on the title bar. Inside the “Home” tab, you can change the font type and size, use bold, apply italics or underline.

To change the font size of the day headings, select all headings. Inside tab “ Home” you can format the font type and size.

1. To format date markers, select all the dates in the cell. Inside the Home tab, you can change the font type and size.

2. Color change

You can change the font color or background color of your calendar. Color coding can be especially useful for marking certain kinds of events.

1. To change the color of the name, click on the line with the name. Inside the “Home” tab, in the drop-down list, you can select the color you need.
2. To change the background color of the heading of your days of the week, select an entire row, click on the paint bucket icon, and choose a fill color. You can also just change the color of the text by following the steps in point 1.
3. To assign a specific color to an event, enter your event or appointment in the date box. Then select the text, click on the paint bucket icon and choose a fill color.

3. Add illustrations

You can personalize your calendar by adding images such as your company logo. For this:

1. Inside the "Insert" tab, click on "Illustrations" and select the "Pictures" option. Upload the image you want to use.
2. The image will be added to your spreadsheet, after which you can drag it to any place in the table.

If you would like to add your logo or image to the top of the calendar, you will need additional space to accommodate the image. For this:

1. Right-click on the first line containing the title and select Paste.
2. Click "Add...line".
3. Repeat these steps for as many lines as you need.
4. To make the background of new lines white, select the new lines, click on the paint bucket icon, and choose white as the color.

1. To remove the border lines above the title bar, select the title bar, click on the border icon and select the “No border” option.

Print a calendar in Excel

Your personalized and formatted calendar may be difficult to print. The sides of the calendar may not fit on the printed page, so you end up with a two-page calendar. Here is how you can fix this problem:

1. Inside the “Page Layout” tab, select the “Orientation” > “Landscape” option.

1. In the "Fit" section, change the width and height to 1 page.

Your calendar will now fit on one page when printed.

How to find the Microsoft calendar template

Microsoft has created many different calendar templates. You can choose from multi-page calendar, yearly calendar, weekly calendar and many more.

To start using the template available in Excel:

1. Click "File" > "New".
2. Enter the word "Calendar" in the search box.
3. You will see a huge number of types of calendars, but for our example, we will take “Calendar for a month for any year”. Click "Create".

This is a calendar for one month (month and year can be any).

1. Select the cell with the name of the month and click on the arrow on the left side of the cell. Select the desired month from the drop-down menu.
2. Enter the calendar year in the cell to the left of the month name.
3. Select the cell with the name of the day of the week located in the upper right part of the calendar and click on the arrow that appears. Select the first day of the month from the drop-down menu.

You can also explore the online catalog of Microsoft templates and select the category of calendars on the left side of the page.

How to insert a calendar using Visual Basic

You can insert a pre-built and populated calendar directly into Excel using the CalendarMaker macro using the Visual Basic Editor. You'll need to turn on Excel's developer mode and use a programming language, but that's easy enough to do, and Microsoft provides sample code for creating a calendar.

1. Enable developer mode

First, you will need to enable developer mode in Excel. For this:

1. Click "File" > "Options".
2. On the left side of the pop-up window, select the Customize Ribbon option.
3. In the Main Tabs section, make sure there is a check mark next to the Developer field, and then click the OK button.

You now have a new tab in your ribbon at the top of your Excel spreadsheet.

2. Insert a calendar with Visual Basic for Applications code

Smartsheet's pre-formatted templates let you create calendars in no time. Months, days of the week, and dates are pre-built, and you have room to add descriptions, comments, and hours for each activity.

Here's how you can use the Smartsheet Calendar Template:

1. Choose a calendar template

1. Open the site and sign in to your account (or try a free 30-day trial).
2. Go to the "Home" tab, click on the "Create" button, and then select the "View Templates" option.
3. Enter the word “calendar” in the “Search templates” field and click on the magnifying glass icon.
4. You'll see a list of suggested templates, but for our example, we'll choose Daily Calendar for 2016. Click on the blue "Use Template" button located in the upper right corner.
5. Choose a name for your template and a location where you want to save it and click OK.

2. Enter calendar data

A template opens containing already formatted months and dates for all of 2016. Sample content is included in the calendar for reference.

1. Specify calendar events in the Action column. You can also add additional details to the Description, Hours, and Comments columns.
2. To add multiple events for the same date, you must create a new row. Right-click on a row and select "Insert Row Above" or "Insert Row Below", and then in this new line specify the month, day of the week, date, and action.
3. If you want to delete a row, right-click on the cell in the row you want to delete and select "Delete Row".

On the left side of each line, you can attach files directly to a task or start a discussion about an event, adding extra context to your calendar.

3. Switch to calendar view

All your calendar data is in this table. Then, with a simple click of a button, you can automatically populate the calendar with this data.

1. On the left side of the toolbar, click on the calendar icon to switch to the calendar view.

Now you can see all your data in the calendar (the current date will be highlighted in blue). You can edit or add events directly from the calendar view by double clicking on the green bar at the top of each cell. You can also change the date of any event by dragging and dropping the green bar to another cell in the calendar.

Any changes to this calendar view will be automatically added to your spreadsheet.

Setting up your calendar in Smartsheet

Customizing your calendar to give it a personal touch is easy in Smartsheet. With just a few clicks, you can add your company logo or use color coding for your events.

1. Changing the color scheme of events

1. Right-click on the green bar and select the "Color Options" option.

A window with a color palette will appear, using which you can change the color scheme of the calendar entry.

2. Change the color scheme of the calendar

1. To change the background color of the entire calendar, select " Account” in the upper left corner of the screen.

Select Color & Logo. With this option, you can change the color of the background, tabs, and calendar strips, as well as choose a color from predefined configurations.

2. Click Save.

You can always return to the default color and logo settings.

3. Adding a logo

The default setting is the Smartsheet logo in the top right corner. You can change this by uploading your own company logo. For this:

1. In the upper left corner, select the "Account" menu item.

1. Select Color & Logo.
2. In the “Logo” section, click the “Select” button and select a file with your image. Once the file has downloaded, click Save.
3. Your new image will be added to the calendar.

Email, print, and share your calendar

Make your calendar available to colleagues, friends and family. You can print, export or send to e-mail your calendar from Smartsheet.

To email a calendar:

1. On the toolbar to the left of the table, click on the envelope icon.
2. Select the "Send as Attachment" option.
3. In the To field, add a recipient or recipients by selecting from your contact list or by typing an email address.

The "Subject" and "Message" fields are pre-filled, but you can delete this text and type your own.

Choose how you want to attach your calendar: how PDF file or Excel spreadsheet, as well as the way the calendar is delivered: immediately or on a regular basis later.

To share your calendar with a link:

1. At the bottom of the calendar, click Post.
2. Use the sliders to select a publishing method.
3. A pop-up window will appear containing a link to publish. You can copy and paste this link, opening in this way general access to the calendar, or use the embed code to add the calendar to any web page.

To print a calendar:

1. On the left side of the toolbar, click on the printer icon.
2. Select date range, paper size, orientation, and more. Then click "OK".
3. A PDF version of your calendar will begin downloading, which you can then print.

The easiest way to create a calendar

There are many ways to create a calendar, but you should always make sure that you choose the one that will save you the most time (for example, templates with pre-built data and functions that are easy to edit). After all, a calendar should help you be more organized without too much effort, not force you to extra work, forcing you to learn how to create it from scratch.

Find out how easy it is to create a calendar. Try a free 30-day trial of Smartsheet.

Are you ready to plan for next year? How about supporting your brand in front of customers as 2016 kicks off?

It's hard to design a monthly plan from scratch or put together hundreds of pages of a personal diary. Don't worry, we've got everything ready! We start with a quality calendar and diary templates.

Print-ready with Custom Design options

GraphicRiver has many printable 2016 calendar and planner templates. All of them are designed for daily, weekly, monthly and yearly planning.

When reviewing options, pay attention to color, font, images, and overall impression. Ask yourself, “Does this fit my brand?” If yes, this is most likely the template for you. Choose the one that aligns with your goals and will present your business in a professional manner.

3. Add your trademarks and customize them

Another consideration is what assets will the template need and how will you set it up? Most of these templates are made for Adobe InDesign, so you will need this program for customization. Or you can work with your printer. This is a viable option.

4. Insert your unique information

In addition to basic assets like photos or your company logo, consider a deeper customization. These could be dates you want to notify clients about, deadlines for your team, international holidays, or other special dates unique to your company or niche.

You can add any information. Open the template files and customize them yourself or work with a professional.

5. Printing and use

New Year's Eve is the time to fill gift bags for your employees or clients. Now is the time to collect what you need, maybe a bottle of wine, decorated with a corporate calendar.

Plan ahead to print the template and have it ready. There are many online printing companies that you can use or work with a local printer.

Any of the printable calendar templates listed in this article may be suitable for your needs. Just add your business information and brand assets and you're ready to print and get results!