How to Use the Deluxe Event Calendar
by Janet Dagostino, Savvy Spreadsheets
Read below for detailed instructions on using our premium automated calendar template, the Deluxe Event Calendar.
The Annual Calendar
This tab gives you an overview of all of your dates in the year.
Today’s date will be highlighted in grey.
On the right-hand side you will see a column with the major U.S. holidays. You can type over these with different holidays if you’d like.
Below the holidays column, there is a section for you to enter any notes for the year.
Next to the holidays column, you’ll see a box called Color Tags. This is your color coding key to help you visually organize your events. Use these event types, or type over them with your own. You can also change your colors by changing the background colors (click here to learn how to do this).
Doubleclick on a date in the Annual Calendar to jump to the Monthly Calendar.
The Monthly Calendar
To enter an event, click on one of the event spaces (next to the date number), and simply type in your event. Press “enter” or click off of the cell when you’re done typing.
To color code an event, right-click on the event to reveal a long menu. Note: if you don’t see this menu, you are probably still in “type” mode. Get off of type mode by pressing “enter,” then try right-clicking again.
Mouseover the “Color Tags” option towards the bottom of the menu, and then select you event type. Your event will now be color coded.
To delete an event, right-click on the event to reveal a long menu. Then select the “Delete Event” option towards the bottom. Your event will now be cleared.
Going back to the Annual Calendar
To go back to the Annual Calendar, doubleclick on the month title.
Printing Your Calendar
The Deluxe Event Calendar is already formatted to print! Each tab is designed to fit on 8.5 x 11 inch letter-size paper.
Feel free to convert it to a pdf file before printing, or print it directly as an Excel file.
Have an unanswered question? Feel free to post it in the comments below!