Outlook: How To Delete Duplicated Holidays

Contributor Icon Contributed by Rob Rogers  
Tag Icon Tagged: Microsoft Outlook  

If you inadvertently add the same holidays to your Calendar more than once, it can not only look rather messy, but also take attention away from other important events you might have on those days. While you could remove them by taking the time to delete each one, there is a much quicker method to force your Calendar to celebrate the holidays only once per event.


1. Go to Calendar.

2. Click View, mouseover Current View and select Events. This will provide a list of all events in your calendar.

3. Right-click a column header and select Field Chooser from the resulting menu.

4. In the Field Chooser box, use the dropdown and select Date/Time fields.

5. Select Created.

6. Drag Created to the Column Headers to add it to the list. Close the Field Chooser box.

7. Now click on the newly added column header (Created). This will sort all of your events by the date that they were added to your Calendar.

8. Find the group of holidays you wish to remove.

9. Select the first holiday in the list that is to be deleted.

10. Scroll down to the last holiday that is to be deleted. Hold down the Shift key and select this holiday. This will highlight all of the holidays that you are going to remove.

11. Press the Delete key. The duplicate holidays will be removed from the Calendar.

12. Click View, mouseover Current View and select Day/Week/Month to return the Calendar to the normal view.

Your Calendar should now only display one set of holidays.

 

40 Comments -


  1. joni said on October 15, 2008

    Great tip!!!!

  2. ron said on October 19, 2008

    Thanks alot,

  3. Sara said on October 23, 2008

    Great instructions!!

  4. Kirsteb said on October 28, 2008

    Thanks a million!

  5. LESLIE said on October 29, 2008

    EXCELLENT METHOD!!!
    LOL AND THANK YOU SO MUCH FOR SHARING IT…

  6. Al said on November 5, 2008

    Thank you. It worked great and it’s much easier than trying to go through the calendar.

  7. Anonymous said on November 24, 2008

    A real time saver – great tip, thanks

  8. mary said on November 25, 2008

    I cannot delete duplicate holidays error reads ‘cannot delete ‘read only’ files? what to do now? help please

  9. davidwilliams84 said on November 30, 2008

    Awesome Tip!!!!

  10. Steve said on December 1, 2008

    Perfect Instructions – You should write a book!

  11. Kojak said on December 21, 2008

    OMG, where have you been all my life? You are my hero!

    Not only was the information spot on, it was presented in a way that even a dummy like me was able to understand the instructions and remove the extra holidays from my Outlook Calendar.

    Thank you for being such a great teacher. And I agree you should write a book.

    k

  12. Greg said on December 24, 2008

    What a pleasure! Thanks a mill

  13. Robert said on December 28, 2008

    You are the SHIZNICK! May Microsoft hire you and pay you millions for such good work!

  14. safaa said on January 10, 2009

    Excellent!

  15. Jennifer said on January 14, 2009

    This was exactly what I was looking for and well written. Thank you so much for your help!

  16. vodkacharp said on February 25, 2009

    this was super helpful! thanks much!

  17. Firth said on March 3, 2009

    Cool

  18. Ann said on March 3, 2009

    This is a great tip. Thank you.

  19. fred said on March 13, 2009

    this works only if the events were created on different days. in my case when I use the instructions above I found all my events were created on the same day for all the main holidays and for several years. I don’t know what to do – maybe just delete ALL event and start over???

  20. Wayne said on March 13, 2009

    I found that there was a “category” column in view * events and when I clicked on that it put all the holidays together. I then reinstalled the holidays using tools * calendar options * add holidays. This fixed the problem I was attacking, which for some reason my calendar had the wrong dates for Memorial Day.

  21. Ralph A. Knebel said on April 3, 2009

    Thanks…worked great4!

  22. Jill said on April 25, 2009

    Bless you!!!! When I inadvertently re-added the Holidays (4 countries worth!!!) and saw the duplicates … Yikes!! Your help was fabulous!!!

  23. carrie said on May 20, 2009

    AWESOME!! Thanks so much

  24. JTJ said on June 5, 2009

    Very great help – and logical.
    Thanks a lot.

  25. Ido said on June 12, 2009

    Great! Many thanks! :-)

  26. Bryan said on August 17, 2009

    Very good, definetely one of the best written instructional tips I have ran across.

  27. pati said on October 20, 2009

    you rock! thanx!

  28. Anonymous said on October 27, 2009

    Very good, well explained, would have taken forever to figure out

  29. AHAA said on November 9, 2009

    Thank you very much… It worked very beautifully…

  30. Anonymous said on December 16, 2009

    Too…Gooddddddd

  31. Aracely said on January 5, 2010

    Plain and simple (dummy talk) for those of us who are not experts to understand! Fantastic job! Thanks for taking the time!

  32. Audrey said on January 5, 2010

    Thanks, just what I needed!

  33. david said on February 16, 2010

    fairly helpful tip in fact it’s helped me out no end

  34. Khaleef @ KNS Financial said on March 2, 2010

    This worked wonderfully! Much better than going one by one through all the Holidays over multiple years!!!

  35. Anonymous said on March 14, 2010

    Thanks a lot. Greate Tip…

  36. frogprof said on March 30, 2010

    SAved me a TON of time — thanks!

  37. Anubhav Bajpai said on November 16, 2010

    Perfect explanation.

  38. Kevin Rittenberg said on October 16, 2011

    Been trying to find the right way to do this for ages!!!
    Worked like a charm. Thanks a million.

  39. Mike said on October 24, 2011

    Great instructions!

  40. Shannon Gonzalez said on November 9, 2011

    WOW! AWESOME! THANKS SO MUCH!!!

 

RSS feed for comments on this post. TrackBack URL

Leave a comment -