When you try to work on a certain spreadsheet using Microsoft Excel, there are instances that you might copy some rows that you are trying to work on.
And with this, you may encounter some duplicate rows wherein you will be needing to delete them. This situation can be a bit difficult to work with especially if you are not familiar with the tool.
In this article, we are going to show how you can remove duplicates on Excel for Mac. We are going to show you some ways on how to this and we are also going to show you a certain tool that you can use for you to remove duplicates.
If in case that you are actually using a Microsoft Office Suite on your Mac, then that would be a great advantage for you. This is because the program had actually a built-in feature that can help you in looking for any duplicates. Here are the things that you should do for you to find all the duplicates that you have.
Step 1: Choose all the cells that you want to search for any duplicates. You can do this by choosing “Select All” for you to select the whole cells.
Step 2: Once that you have selected all the cells that you want, go ahead and choose “Data” located at the top of your screen. Then after that, go ahead and choose “Remove Duplicates”.
Step 3: Then, a dialogue box will then appear on your screen. As you can see on your screen, the first row of the sheet was deselected. This is because the option “My data has headers” box has a check mark beside it. In this situation, all you have to do is to unmark the “My data has headers”. Once done, you will then see that everything has been highlighted.
Step 4: Since the whole table was selected again, all you have to do is to press the “OK” button for you to remove any duplicates. Once done, then all the rows that have duplicate will then be removed aside from the one that has been deleted. The details about the changes that had happened will be shown on a pop-up box that will appear on your screen.
There is also another tool that you can use in your Excel for you to know and remove all the duplicate data that you have. This is by using the “Advanced Filter”. Using this tool can be used if you are actually using Excel 2003 on your Mac. Here is how you can use Advanced Filter.
Step 1: Go ahead and launch Excel on your Mac.
Step 2: Then after that, go ahead and choose “Select All” for you to highlight your spreadsheet.
Step 3: Once that you have selected a table, go ahead and click on “Data” and then choose “Sort and Filter”.
Step 4: And then, go ahead and choose the “Advanced” option. And in case that you are using the Excel 2003, just simply go ahead and click on the “Data” and then click on the “Filters” from the drop-down menu and then choose “Advanced Filters”.
Step 5: From there, go ahead and choose “Unique records only”. And then click on the “OK” button
Step 6: Once that you have confirmed the action, all the duplicates that you have on your spreadsheet will be removed.
The method that we are going to show you here is actually good enough for those smaller spreadsheets. This is another way for you to locate and remove any duplicates that you have.
In this method, we are going to remove all the duplicates that you have using the “replace” feature which is a built-in function for every Microsoft Office product. Here are the things that you should do.
Step 1: Launch the spreadsheet that you want to work on.
Step 2: After that, go ahead and choose on the cell which contains the content that you would want to look for and replace and then have it copied. From here, all you have to do is to copy the data
Step 4: Once that the feature is up, all you have to do is to paste the data that you have copied earlier. Do this n the “Find What” section.
Step 5: Once that you have already found what you are trying to look for, go ahead and press on the “Options” button. And then go ahead and choose the “Match entire cell content.
Step 6: After that, go ahead and input a certain value on the “replace with” field. And once that you are done entering the value, go ahead and click on the “Replace All” button.
Step 7: You will then be able to notice that all the data that you have found its duplicate will then be replaced with the value that you have entered earlier. This way, you will be able to know which cells contain duplicates.
Step 8: Now, for you to be able to retain one copy of the duplicate that you are trying to look for, go ahead and paste the original content that you have replaced.
Step 9: Now that you have found out all the duplicates that you have on your spreadsheet, go ahead and click on the Ctrl button while you are clicking on the cells that contain your duplicate.
Step 10. After you have highlighted all the rows that you would want to remove, go ahead and right click on one of the highlighted and then choose the “Delete” button.
Step 11. Once that you are done with the process, you will then see that all the rows that remained on your spreadsheet will then have a unique value.
Now, aside from the methods that we have shown you above, there is
Just like the duplicates that you have on your Excel, the
The reason for this is that the duplicate files that you have stored on your Mac unknowingly actually eats up a lot of storage space that can also cause your Mac to run slow.
Lucky we have the what we called the “byte-to-byte” comparison. Because this way, you will be able to get accurate results. And one of the most awesome thing that the
For you to be able to know how easy and fast the iMyMac-PowerMyMac's Duplicate Finder is, go ahead and follow the step by step method that we are going to show you.
The first thing that you need to do is to download the iMyMac-PowerMyMac from our official website. Once that you have successfully downloaded the program, go ahead and install it on your Mac.
Once that you are done, go ahead and launch the
On the top side of your screen, you will see there a list of modules that the
Once that you have clicked on the “Scan” button, the
Once that the scanning process is done, the
After that, go ahead and choose all the file types that are shown on your screen as the result of the scanning process. Once that you click on a single file type, you will then be able to see all the duplicate items that you have.
From here, all you have to do is to choose all the items that you would want to remove from your Mac’s system. And once that you are done choosing all the files that you want to delete, go ahead and simply click on the “Clean” button.
As you can see, it is very easy to remove all the duplicates that you have on your Excel. We know how irritating it is to have more than one data that you need. That is why we have provided
And, just like the duplicates that you have on your Excel, there are also instances that you have a lot of duplicates that you have on your Mac. This is because sometimes we tend to download a single file several times. There are also instances that there are some photos or videos that we tend to save on our Mac.
Because of this, we have the perfect tool that you can use which is the iMyMac-PowerMyMac's
This includes your data, photo, videos, music and more. The
Always keep in mind that if these duplicate files that you have on your Mac actually take up a lot of storage space and that it can cause your Mac to slow down. That is why deleting these duplicate files is one of the most important things that you should do.
Have the iMyMac-PowerMyMac installed on your Mac and this will be more than enough for you to maintain your Mac.
Last updated: February 18, 2019
Leave a Comment