Excel Templates | Excel Spreadsheets | 2010 Calendar



2010 Calendar

Posted on October 27, 2009
Filed Under Calendar | 22 Comments

Year 2010 is about to come. An excel calendar 2009 that I created last year is the first calendar I made. There are many types I made for 2009 calendars, like monthly, three monthly, six monthly where you can customize those calendars with your events and holidays.

2010 Calendar

This calendar is the first 2010 excel calendar type I release. This is a one page, 12 month calendar where you can colorize the date based on your reminders, events and holidays. There is two worksheets in this calendar. The first worksheet is reminder-event-holiday worksheet where you can put your reminders, events and holidays in corresponding columns. If you put the same dates for those three, the first priority will go to reminder, then event and the last priority is holiday. The color of the dates will be the same with the corresponding column colors.


Excel Calendar Setup

The second worksheet is the calendar worksheet where you can see your customize 12 month worksheet with color on the dates that you have customized. And you can replace the Panda picture at the left side of the calendar with your picture.

And there is a 2010 excel calendar for excel 2007 version. The difference between the calendar for excel 2007 version and for excel before 2007 is the 2007 version can accommodate until 5 different colors in the calendar. So, if you want to separate your events into three different color, for example you want to separate your private, company, and friends events, you can do that with this version.

You can download the 2007 version here.

And you can download the 97 – 2003 version here.

And for Openoffice version, you can download it here.



Comments

22 Responses to “2010 Calendar”

  1. prasath on October 30th, 2009 10:17 am

    it is very useful to all of us
    thank you
    prasath

  2. Sarah on November 21st, 2009 10:56 am

    Hi, I have downloaded your calendar and it is precisely what I have been looking for, except that I would like to add another range of dates to be displayed.

    I am a spreadsheet novice, but I have added a new Name to the data spreadsheet for the dates I need. Can you tell me how to incorporate these into the calendar spreadsheet, please?

    Many thanks,
    Sarah

  3. Charly on November 28th, 2009 8:13 pm

    Disculpen que no hable inglés. He bajado la version “You can download the 2007″ y no obtuve ningun archivo excel. ¿podrian verificar el link?
    Muchas gracias

    Sorry to not speak English. I downloaded the version “You can download the 2007″ and got no excel file. Would you be able to verify the link?
    Thank you very much

  4. md on December 11th, 2009 6:35 pm

    it is very useful to all of us
    thank you

  5. Ventzislav Tzvetkov on December 21st, 2009 1:31 pm

    Nice Excel template. Very useful and looks good.
    I have used it to make my work absence schedule for the next year.
    Regards.

  6. Jerry K on December 22nd, 2009 4:55 pm

    After downloading and unzipping the 2007 template file …. how do you use it …. ???? it’s all xml files ????

  7. mully on January 12th, 2010 7:31 am

    thank you very much
    ;)
    very useful.

  8. zoe on January 15th, 2010 4:00 am

    I also just had all xml files in the folder, how to I make this into an excel spreadsheet?

  9. Simon Wantling on February 4th, 2010 7:43 pm

    Brilliant template, so thanks. I would like to change the colours so that appear in the calendar. Could you possibly tell me how to do that? Also, if I wanted to add another catagory is that possible? I’m using the 2003 version.

    Thanks very much.

  10. leigh on March 11th, 2010 5:47 am

    Just worked it out…for anyone else out there with same issue. Unprotect worksheet then drag and drop new lines in place. BRILLIANT!! ;-)

  11. Girish on March 11th, 2010 10:25 am

    Hi,

    I can so only xml files. Where do i locate the actual Excel file ?

    Thanks

  12. Dshea on March 18th, 2010 12:55 pm

    I downloaded the 2007 version but the spreadsheet does not open. Also I would like to be able to put in a range of dates for vacation sceduling purposes. How can i do that?
    Great calendar though (I tried the other version)
    Thank you

  13. SRINIVAS on March 25th, 2010 6:06 am

    i have more than 3 events to manage per day (want to have 10 per per day). how do i add this in the calender. if possible can you send me the revised templete to my above mail id.

  14. Chinjoo on March 30th, 2010 10:11 am

    Hi, Thanks for the template! Just to find out how to extend the Calender for year beyond 2011?

    Rdg,
    CJ

  15. Allison Jablonko on May 18th, 2010 11:02 am

    Your 2010 Calendar Template is JUST what I have been looking for: the whole year on one page! Unfortunately, though I have tried downloading all three options, I cannot later open them. An “error” occurs. My Excel is 2004 for Mac Version 11.5.8 (100209).

    Any help will be appreciated!

    Allison

  16. Ed on July 26th, 2010 4:24 pm

    Hi – great tool! How do update the calendar to reflect a 12 month period that is not Jan – Dec … for example June through to May ?
    Thanks

  17. Chris a on August 13th, 2010 3:16 pm

    Fabulous! It would be great to get my hands on the 2011 version. Are you planning one?
    Thanks,
    Chris

  18. Barbara on October 18th, 2010 10:24 pm

    I would also like to know if you have plans to post a 2011 version. This calendar is great and we use it at work. Thanks!

  19. David from Healthy Living Tips on August 4th, 2011 8:28 pm

    Sounds great. Is their a 2011 version?

  20. Yogesh on September 22nd, 2011 1:25 pm

    Hi, Love the calendar, is there any way to have more than 3 reminder options, I am a novice and would appreciate and help.
    Yogesh

  21. RoxAnn on February 13th, 2012 2:45 am

    PLEASE….PLEASE
    I need to used this 2009 awesome calendar for 2012. Any help would be greatly appreciated. Thanks

  22. Paul on February 5th, 2013 2:48 am

    Great Calendar. What I need to do is have information I need to be able to add columns and have multiple entries (with different data on any given week I know how to change the view from days to weeks so that is not a problem.
    Ideally there would be up 8 lines under each week and the entry wouild be display on its own line with case number in the cell and level of intensity based on predefined authority levels (0-2.5, 2.5-5.0, 5.0-10.0 and 15 and above). With point of contact, case title, due date in a comments field if possible. This information can be taken/ updated from the spreadsheet. I am currently using Excel 2003 (work is slow on change). Any suggestions on how I can achieve to task or as close as I can get would be greatly appreaciated.
    Thanks for your help in advance
    Paul

Leave a Reply