Libreoffice change theme of the sheet

In Libreoffice sheets can have a theme that will change the look of sheets i.e make the text and background appear in different pattern. 
Let us say we have the following sheet, which is the normal pattern.

 


To change the theme, click on Format->Spreadsheet Theme 

Select any of the themes that you want For eg PC Nostalgia looks like this. 

Remove duplicate entries from a column in libreoffice.

Very often while dealing with data in Excel files, we might have rows of data that might have got repeated several times. If we want to remove these duplicate rows we can follow the following steps.

Let us say we have the following excel file 

We can see that the row of names has the same name repeated more than once. If we want to view only those rows which are unique then first select the column from which the duplicate entries have to be removed from

Now click data->More filters->standard filter 

In this make sure none of the columns is chosen in the filed name options, now click on the small triangle labelled options at the left hand side to open more options.

From this tick the option "No duplications" Click OK. 

Now we should see that only the unique rows would be listed .