Horizontal Yearly Calendar Templates
Printing a horizontal yearly calendar can provide something new - a break from the traditional blocky calendars. We've created 4 different designs for you to choose from, and each of them allows you to change the year, start month, and start day. For even greater variety, take advantage of the Themes feature in Excel to easily change both the color and font.
Horizontal Yearly Calendar (Light)
for Excel
Description
Customizing the Calendar: The image below shows the settings within each spreadsheet that you can modify to customize your calendar. In addition to choosing the year, start month and start day, you can choose which days of the week to highlight as the weekend days. In the Weekend field, enter a string of 7 characters for Monday through Sunday, where 1 (one) is a weekend and 0 (zero) is a normal day.
Customizing Month and Weekday Labels: You can also use the Months and Weekdays columns to change the labels used in the calendar. For example, you may want to modify the month names for other languages or use different abbreviations.
Changing Colors and Fonts: To quickly choose a different combination of color and fonts, go to Page Layout > Themes and browse the options built into Excel. If you want to change some of the colors manually, you may need to used in these templates. Go to Home > Conditional Formatting > Manage Rules and select "This Worksheet" to see all of the rules used in the worksheet.
Horizontal Yearly Calendar (Bold)
for Excel
Description
This screenshot shows what happens when you choose a start month other than January. Note how the title and the month labels change. This would be an example of what you might do for a school calendar.
Horizontal Yearly Calendar with Holidays
for Excel
Description
This version includes some common U.S. holidays and observances. The dates included in this worksheet will update automatically when you change the year and month.
Customizing the List of Holidays: If you want to edit the list of holidays, you can enter the dates for the holidays manually instead of using formulas. To change how the holidays are highlighted in the calendar, edit the conditional formatting rules (there is a separate rule to reference each column of dates).
Horizontal Yearly Calendar (Seasons)
for Excel
Description
This version is similar to the Bold design except that the months are highlighted with different colors for the different seasons.
Horizontal School Year Calendar
for Excel
Description
This version is in portrait orientation and was designed to allow you to manually add events to the calendar. This example is showing a school calendar and a cell border above the italicized text helps show the dates described by the text.
