Skip to content

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

28 de April de 2021

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 find and remove duplicate values ​​in Calc from LibreOffice In a simple way.

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 of which 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 remove duplicate values ​​in LibreOffice Calc As simple as opening a Word document without Microsoft Office, you have to go by 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 to be evaluated. Once selected, go to the top where the bar with different options is located and select “Format”.

Once this is done, a drop-down will open with several options, at the end of this there is a call “Conditional format” 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 select the conditions that you want to apply, there are three drop-downs, in the first place the condition “The cell value is”, then select “Duplicate” in the second, and in the last “New style”.

find duplicate values

Then in the same window, go to the tab called “BackgroundWhich 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 “To accept” and ready.

Once the background is chosen, save the changes in general, giving it “To accept”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 in 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 the 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 dropdown called “Field Name”, this 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.

  duplicate values ​​in LibreOffice Calc

Follow the steps!

Then and in that same window, you will notice that there is a button called “OptionsPress it and it will show the advanced options. Here you will choose “Range contains column labels” Y “No duplicates“, Go ahead “To accept”To confine the changes and voila.

In this way, all the steps to find and eliminate duplicate values ​​in LibreOffice Calc 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 take 10 minutes and is completely effective. so you can sit down and start creating the sheets you want at will.