Outlook: How To Delete Duplicated Holidays

Posted November 6, 2007 by Rob Rogers in 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.

 

About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.

  • joni

    Great tip!!!!

  • ron

    Thanks alot,

  • Sara

    Great instructions!!

  • Kirsteb

    Thanks a million!

  • LESLIE

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

  • Al

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

  • Anonymous

    A real time saver – great tip, thanks

  • mary

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

  • davidwilliams84

    Awesome Tip!!!!

  • Steve

    Perfect Instructions – You should write a book!

  • Kojak

    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

  • Greg

    What a pleasure! Thanks a mill

  • Robert

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

  • safaa

    Excellent!

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

  • vodkacharp

    this was super helpful! thanks much!

  • Firth

    Cool

  • Ann

    This is a great tip. Thank you.

  • fred

    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???

    • Wayne

      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.

  • Ralph A. Knebel

    Thanks…worked great4!

  • Jill

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

  • carrie

    AWESOME!! Thanks so much

  • JTJ

    Very great help – and logical.
    Thanks a lot.

    • Ido

      Great! Many thanks! 🙂

  • Bryan

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

  • pati

    you rock! thanx!

  • Anonymous

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

  • AHAA

    Thank you very much… It worked very beautifully…

  • Anonymous

    Too…Gooddddddd

  • Aracely

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

  • Audrey

    Thanks, just what I needed!

  • david

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

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

  • Anonymous

    Thanks a lot. Greate Tip…

  • frogprof

    SAved me a TON of time — thanks!

  • Anubhav Bajpai

    Perfect explanation.

  • Kevin Rittenberg

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

  • Mike

    Great instructions!

  • Shannon Gonzalez

    WOW! AWESOME! THANKS SO MUCH!!!

  • Jerry M.

    And I thought I knew it all, thanks.

  • DMomma

    It’s Nov. 2012, and I’m so glad these instructions are still posted! I Googled the duplicate holidays problem and selected the first three results — yours were the best. Even several versions of Outlook later, the instructions were easy enough to follow along. Thanks so much!

    • David Kirk

      @DMomma – Thanks for the kind words. I am very happy that we could help.

  • Poosa

    Thank you very much for the detailed steps. Simple but very effective… Learnt something new about outlook!!

  • Kat Kay

    Perfect.

  • tak

    THANKS!!! great walk through

  • Mike

    great tip – thank you!

  • Judemon

    Back to work after Christmas holidays, public holidays had disappeared in Outlook (among other snags) so I impatiently re-imported them. I assume our server eventually caught up with things and I ended up with duplicates, annoying me no end! Over 10 years worth of duplicates, so I am very appreciative of this tip, thanks!!