Ask Your Question

Filter values Not used in whole spreadsheet

asked 2020-10-15 12:41:06 +0100

Hi everyone I'm new to using LibreOffice, want to know for example I have Values in Column that may or may not be used anywhere in the spreadsheet, is there a way to filter values that are not used and remove them?

edit retag flag offensive close merge delete


@zortxmundi, What do you mean with "values that are not used"?

LeroyG gravatar imageLeroyG ( 2020-10-16 02:27:01 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2020-10-15 23:01:17 +0100

m.a.riosv gravatar image

Maybe Menu/Tools/Detective/Trace dependents could help.

edit flag offensive delete link more


But this functions work one cell at a time. Or not?

LeroyG gravatar imageLeroyG ( 2020-10-15 23:22:52 +0100 )edit

But you can select e.g. a column, and the first one is marked, so you not need to select exactly every cell,

m.a.riosv gravatar imagem.a.riosv ( 2020-10-15 23:41:48 +0100 )edit

answered 2020-10-15 19:32:44 +0100

LeroyG gravatar image

Yes, there are a few ways. Here one:

  • Select the data, choose menu Data - AutoFilter.
  • When prompted if Do you want the first line to be used as column header?, answer Yes if first line is no data.

To continue, take a look at LibreOffice Help on Applying AutoFilter.

Once filtered, you can copy and paste, or delete the visible data.

Tested with LibreOffice (x86); OS: Windows 6.1.

Add Answer is reserved for solutions.

Press edit below your question if you want to add more information; also can comment an answer.

Check the mark (Correct answer mark) to the left of the answer that solves your question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-10-15 12:41:06 +0100

Seen: 15 times

Last updated: Oct 15