Excel Calendar PROExcel Calendar PRO is an extension of Vertex42's free Excel Calendar. Our free calendar template has had over 600,000 downloads! Excel Calendar PRO provides a few additional features, such as mini calendars and a button to automatically create a 12-month calendar in a new workbook, beginning with the month of your choice. It allows you to add birthdays, anniversaries, and other special events. It also includes holidays such as Easter, Christmas, Mother's Day, Father's Day, Labor Day, Valentine's Day and important dates-to-remember such as Daylight Savings and the dreaded Tax deadline.
FEATURES:1) Annual holidays and events
2) Convenient Previous and Next Month Calendars Excel Calendar PRO includes two linked images that display the previous and next month in the form of mini calendars. (These can be seen in the screenshot).
3) Simple Dynamic Color Scheme Controls In order to add a bit of style to the calendar, you can modify the color palette using a very simple set of color controls. The HUE changes the main color scheme based upon the spectrum above the slider. The saturation varies from gray (0) to full color (100). ![]() Dynamic color scheme controls. This calendar uses Conditional Formatting to vary the background colors based upon whether the day of the week is Saturday or Sunday. 4) Automatically Copy the Calendar to a New Workbook
Excel Calendar PRO includes a macro button that lets you automatically copy the calendar into a new Excel workbook. The values and formats are copied, including the column widths and the color scheme. The mini calendars are also copied into the new workbook. This creates a macro-free calendar in Excel that you can customize to your heart's content. View the Screenshot to see the buttons and controls.
5) Quickly Create a 12-Month Calendar
Using the "Create 12-Month Calendar" button, you can easily create a customizable calendar in a new workbook, where each month is on a separate worksheet. An option in the Settings worksheet allows you to modify how many months are created, so you can create a 6-month or 24-month calendar. This is great for creating academic calendars which usually start in July or August and run for 13-14 months. Creating calendars using this macro is the preferred way to use Excel Calendar PRO because the calendar is created in a separate macro-free workbook that allows you complete control over formatting and event entry. Using features already built into Excel, you could (1) merge cells to add events that spans multiple days, (2) add hyperlinks that link to special event sites like conferences, (3) add images and clip-art. 6) Easy Printing The excel calendar has already been set up to print to a normal letter-sized sheet of paper (in landscape). However, you can customize the spreadsheet to print to other sizes and orientations (by changing column widths and font sizes and/or using Excel's page-setup to fit the spreadsheet to other sizes). Printing a Specific Range of Cells to Any Size Paper in Excel:
7) *NEW* - Switch to Monday-first Due to the increasing number of requests from our international customers, you can now change the calendar so that Monday is the first day of the week, with a single click! This is done using a checkbox like the one below: ![]() What This Template Won't DoIt won't store the entries that you make into a database so that you can keep a history of your appointments or plans. Don't expect this calendar to behave like Outlook or other calendar software. It doesn't remind you when events are coming up.
|
|||||
|
|
|