## Apex Technology Blog
Apex Technology has been serving the Carolinas since 1998, providing IT Support such as technical helpdesk support, computer support and consulting to small and medium-sized businesses.
[ Categories ](https://trustapex.directivesites.com/blog/categories "Categories")
[ Tags ](https://trustapex.directivesites.com/blog/tags "Tags")
[ Categories: All Categories ](https://trustapex.directivesites.com/javascript:void(0); "Categories")
Search...Suggested keywords
[ x ](https://trustapex.directivesites.com/javascript:void(0);)
# Tip of the Week: Remove Duplicate Values in Excel
[Apex Technology Blog ](https://trustapex.directivesites.com/blog/categories/blog) [Tip of the Week](https://trustapex.directivesites.com/blog/categories/tip-of-the-week)
[Tim Campbell](https://trustapex.directivesites.com/blog/blogger/tim-campbell)
Wednesday, 22 June 2022
[ 0 Comments ](https://trustapex.directivesites.com/blog/tip-of-the-week-remove-duplicate-values-in-excel#comments)
[  ](//trustapex.directivesites.com/images/easyblog_shared/June_2022/06-22-22/spreadsheet_391564493_400.jpg "Tip of the Week: Remove Duplicate Values in Excel")
Microsoft Excel is a great tool that can provide loads of value to power users, but oftentimes users just don’t have the know-how to make the most of it. Thankfully, you have power users like us to guide you through some of the more intricate processes in the spreadsheet software. Let’s look at one such process: removing duplicate values in columns.
## How to Remove Duplicate Values in Columns
It turns out that Microsoft Excel makes this process extraordinarily easy to pull off. There is an option built right into the program which enables you to do this. Begin by opening up whichever spreadsheet you want to remove duplicate values in.
Next, **select the cells** which comprise the spreadsheet. If you want to do the whole spreadsheet, you can use **Ctrl + A** to select the entire thing.
The next step is to go to the **Data tab** and select the **Data Tools** button in the ribbon. From here, you select **Remove Duplicates** from the drop-down menu. A menu should open up with some options to choose from. If you want to keep your headers, if your spreadsheet uses them, then **select the box for My data has headers**. This will ignore the first row of your spreadsheet.
Underneath this option, you should see the list of columns in your spreadsheet. **Select the columns for which you want to delete duplicate values**. To make things easier, you can use the **Select All** or **Unselect All** options at the top of the box. Once you are ready, you can **click OK**. A dialog box will appear telling you how many duplicate values have been deleted, as well as how many unique values remain.
And that’s it! Super easy, right?
What are some other tips you would like to see from us in the future? Be sure to let us know in the comments, and for more great tips and tricks, subscribe to Apex Technology’s blog.
[ ](https://trustapex.directivesites.com/javascript:void(0);) [ ](https://trustapex.directivesites.com/javascript:void(0);) [ ](https://trustapex.directivesites.com/javascript:void(0);)
Tags:
[Microsoft Office](https://trustapex.directivesites.com/blog/tags/microsoft-office) [User Tips](https://trustapex.directivesites.com/blog/tags/user-tips) [Tip of the Week](https://trustapex.directivesites.com/blog/tags/tip-of-the-week)
[ 5 Huge Benefits of Proactive Managed IT ](https://trustapex.directivesites.com/newsletter-content/5-huge-benefits-of-proactive-managed-it)
[ 5 Steps You Can Take to Keep Your Network and Data... ](https://trustapex.directivesites.com/blog/5-steps-you-can-take-to-keep-your-network-and-data-secure)
About the author
[  ](https://trustapex.directivesites.com/blog/blogger/tim-campbell)
[Tim Campbell](https://trustapex.directivesites.com/blog/blogger/tim-campbell)
[ ](https://trustapex.directivesites.com/blog/blogger/tim-campbell)
Tim Campbell is the President of Apex Technology which he founded in 1998. In 2009, Apex launched its Managed IT Services division. Since its inception, Apex has become the premier Managed IT Services Companies in the Charlotte metro area specializing in Managed IT, Security, Data Backup & Cloud Computing Solutions.
Author's recent posts
[More posts from author](https://trustapex.directivesites.com/blog/blogger/tim-campbell)
[ Wednesday, 05 August 2026 5 Essential Steps to a More Secure Wireless Network ](https://trustapex.directivesites.com/blog/5-essential-steps-to-a-more-secure-wireless-network)
[ Monday, 03 August 2026 Building a Business Workspace That Fits In Your Backpack ](https://trustapex.directivesites.com/blog/building-a-business-workspace-that-fits-in-your-backpack)
[ Friday, 31 July 2026 The Power of Modern VoIP ](https://trustapex.directivesites.com/blog/the-power-of-modern-voip)
Comments
No comments made yet. Be the first to submit a comment
**** Already Registered? [Login Here](https://trustapex.directivesites.com/component/users/login?return=aHR0cHM6Ly90cnVzdGFwZXguZGlyZWN0aXZlc2l0ZXMuY29tL2Jsb2cvdGlwLW9mLXRoZS13ZWVrLXJlbW92ZS1kdXBsaWNhdGUtdmFsdWVzLWluLWV4Y2Vs&Itemid=101)
Thursday, 06 August 2026
Subscribe to the blog (Please fill in your email address to subscribe to updates from this post.)
**Captcha Image**