How to find and remove duplicate values ​​in Libre Office calc?

Calc is one of the best tools today for creating spreadsheets. This is not only due to its varied functions (which resemble and surpass those of its Microsoft counterpart), but also because of its versatility when editing documents. That is why today’s goal is to easily find and remove duplicate values ​​in LibreOffice Calc .

And it is because of Libre Office itself that calc is so good. Since thanks to being created with an open source for being free software, it has many functions that its skills lack, such as, of course, the ability to edit documents with much more freedom.

Detect these cells

To learn how to find and eliminate duplicate values ​​in LibreOffice Calc as simple as opening a Word document without Microsoft Office , you have to go through parts, since detecting and eliminating are two very different steps.

The first thing is to know which cells are repeated, for this you must first choose the range of cells that are going to be evaluated. Once selected, go to the top where the bar with different options is and select ” Format “.

Once this is done, a drop-down with several options will open, at the end of this there is a called “Conditional Formatting”, stand on top of it. In this way another option will appear next to it called ” Condition ” select it.

Once this is finished, a new window will appear with a new section. Here you select the conditions that you want to apply, there are three drop-downs, in the first place the condition “The value of the cell is”, then select “Duplicate” in the second, and in the last “New style”.

 

Then in the same window, go to the tab called ” Background ” that is at the top. Once you have selected it, you will see a new section, where you must select the background style you want (it is really a color), with this color the duplicate cells will appear, click ” OK ” and that’s it.

Once the background is chosen, save the changes in general, giving it ” OK ” where you chose the first options and that’s it. The first step in finding and removing duplicate values ​​in LibreOffice Calc completed.

Find and remove duplicate values ​​in LibreOffice Calc

In addition to the function explained, it is worth highlighting some other tools such as putting a background image on a calc sheet in LibreOffice Writer and in turn making a dynamic bar or pie chart in LibreOffice’s Calc , essential at some point.

Now if it is time to eliminate duplicate values ​​at once, for this you must first select the column where there is a duplicate cell, this is simple, you just have to click on a cell in that column to choose it.

Then go to the menu or bar at the top and choose the option ” Data ” and then in the drop-down menu that appears next, position yourself above ” Filter “, again another batch of options will appear, in this press “Standard filter”.

Now in the section that will open, you have to select the parameters that will be added to the filter. There is a drop-down called “Field name”, it will appear automatically filled with the option you previously chose.

Next to this same drop-down there is another one called “ Value ”, select this and choose the option “Not empty” , so that the program takes into account all the cells that are not empty.

 

Follow the steps!

Next and in that same window, you will notice that there is a button called ” Options ” press it and it will show the advanced options. Here you will choose “The interval contains column labels” and ” No duplicates “, click ” OK ” to confine the changes and that’s it.

In this way, all the steps to find and eliminate duplicate values ​​in LibreOffice Calc are already completed so that your sheet is completely free of unnecessary copies and ready for any use.

That is how simple it is to work with Calc and although it seems a long process, in practice it does not last 10 minutes and is completely effective. so you can sit down and start creating the sheets you want at will.

 

Leave a Comment