How to remove duplicate public holiday entries in Outlook?
If duplicate public holidays take place in your calendar folder in Microsoft Outlook, it will be time-consuming and tedious to delete the duplicate holiday entries one by one. In this article, we will introduce an easy way to remove duplicate public holiday entries in Microsoft Outlook.
Part 1: Remove all holiday entries from a calendar
Part 2: Import holiday entries into a calendar
Part 1: Remove all holiday entries from a calendar
The first part will guide you to remove all holiday entries from a calendar in Microsoft Outlook. Please do as following:
Step 1: In the Calendar view, open a calendar folder that you will remove holiday entries from.
Step 2: Change the displaying view of opening calendar:
- In Outlook 2007, click "View" > "Current View" > "Events".
- In Outlook 2010 and 2013, click "Change View" > "List" on the "View" tab.
Step 3: Arrange all appointments by Categories by clicking "Categories" in the Arrangement box on the "View" tab in Outlook 2010 and 2013.
In Outlook 2007, click "View" > "Arrange By" > "Categories".
Note: You can also sort appointments by categories by clicking "Categories" at the Column Header.
Step 4: Select all appointments marked as the category of "Holiday", and then press the "Delete" key.
Note: Holding the "Shift" key, you can select all adjacent appointments by clicking the first one and the last one.
AI Mail Assistant in Outlook: Smarter Replies, Clearer Communication (one-click magic!) FREE
Streamline your daily Outlook tasks with the AI Mail Assistant from Kutools for Outlook. This powerful tool learns from your past emails to offer intelligent and accurate responses, optimize your email content, and help you draft and refine messages effortlessly.
This feature supports:
- Smart Replies: Get responses crafted from your past conversations—tailored, precise, and ready to go.
- Enhanced Content: Automatically refine your email text for clarity and impact.
- Effortless Composition: Just provide keywords, and let AI handle the rest, with multiple writing styles.
- Intelligent Extensions: Expand your thoughts with context-aware suggestions.
- Summarization: Get concise overviews of long emails instantly.
- Global Reach: Translate your emails into any language with ease.
This feature supports:
- Smart email replies
- Optimized content
- Keyword-based drafts
- Intelligent content extension
- Email summarization
- Multi-language translation
Best of all, this feature is completely free forever! Don’t wait—download AI Mail Assistant now and enjoy!
Part 2: Import holiday entries into a calendar
This part will guide you to import public holiday entries of a specified country or region into your calendar in Microsoft Outlook.
Import holiday entries into a calendar in Outlook 2010 and 2013
Step 1: Click "File" > "Options".
Step 2: In the Outlook Options dialog box, click "Calendar" in the left bar.
Step 3: Go to the "Calendar options" section, and click the "Add Holidays" button.
Step 4: In the Add Holiday to Calendar dialog box, check a location whose holidays you will import to your calendar, and click the "OK" button.
It will take a minute to import the holidays of specified location into your calendar. Be patient to wait.
Step 5: Then a dialog box comes out and tells you the holidays have been added to your calendar. Click "OK".
Step 6: Click the "OK" button to exit the Outlook Options dialog box.
Note: The public holidays will be added into the default calendar folder of default data file. If the duplicate holiday entries do not stay in the default calendar folder, this method is unable to solve your problem.
Import holiday entries into a calendar in Outlook 2007
Step 1: Click "Tools" > "Options".
Step 2: In the Options dialog box, click the "Calendar Options" button on the "Preferences" tab.
Step 3: In the Calendar Options dialog box, click the "Add Holidays" button in the "Calendar options" section.
Then you can follow the same steps we talked about in Outlook 2013 to finish importing holidays.
Best Office Productivity Tools
Breaking News: Kutools for Outlook Launches Free Version!
Experience the all-new Kutools for Outlook with 100+ incredible features! Click to download now!
📧 Email Automation: Auto Reply (Available for POP and IMAP) / Schedule Send Emails / Auto CC/BCC by Rules When Sending Email / Auto Forward (Advanced Rules) / Auto Add Greeting / Automatically Split Multi-Recipient Emails into Individual Messages ...
📨 Email Management: Recall Emails / Block Scam Emails by Subjects and Others / Delete Duplicate Emails / Advanced Search / Consolidate Folders ...
📁 Attachments Pro: Batch Save / Batch Detach / Batch Compress / Auto Save / Auto Detach / Auto Compress ...
🌟 Interface Magic: 😊More Pretty and Cool Emojis / Remind you when important emails come / Minimize Outlook Instead of Closing ...
👍 One-click Wonders: Reply All with Attachments / Anti-Phishing Emails / 🕘Show Sender's Time Zone ...
👩🏼🤝👩🏻 Contacts & Calendar: Batch Add Contacts From Selected Emails / Split a Contact Group to Individual Groups / Remove Birthday Reminders ...
Use Kutools in your preferred language – supports English, Spanish, German, French, Chinese, and 40+ others!
🚀 One-Click Download — Get All Office Add-ins
Strongly Recommended: Kutools for Office (5-in-1)
One click to download five installers at once — Kutools for Excel, Outlook, Word, PowerPoint and Office Tab Pro. Click to download now!
- ✅ One-click convenience: Download all five setup packages in a single action.
- 🚀 Ready for any Office task: Install the add-ins you need, when you need them.
- 🧰 Included: Kutools for Excel / Kutools for Outlook / Kutools for Word / Office Tab Pro / Kutools for PowerPoint