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.

Advertisement

Horizontal Yearly Calendar (Light)

for Excel
Horizontal Yearly Calendar (Light)
⤓ Download
For: Excel 2010 or later & Excel for iPad/iPhone

License: Private Use (not for distribution or resale)

Advertisement

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.

Options for Customizing the Horizontal Calendar

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 edit the Conditional Formatting rules 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
Horizontal Yearly Calendar
⤓ Download
For: Excel 2010 or later & Excel for iPad/iPhone

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.

License: Private Use (not for distribution or resale)

Horizontal Yearly Calendar with Holidays

for Excel
Horizontal Yearly Calendar
⤓ Download
For: Excel 2010 or later & Excel for iPad/iPhone

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.

License: Private Use (not for distribution or resale)

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
Horizontal Yearly Calendar (Seasons)
⤓ Download
For: Excel 2010 or later & Excel for iPad/iPhone

Description

This version is similar to the Bold design except that the months are highlighted with different colors for the different seasons.

License: Private Use (not for distribution or resale)

Related Content

 

LIKE THIS TEMPLATE?

Follow Us On ...

FB  G+  PIN  TWEET  LI 

Related Templates

Sponsored Listings 


   Share: