Ask Your Question

How do I delete filters created

asked 2018-08-15 15:02:43 +0100

Mary M gravatar image

I set up filters on my Libre Calculate document. I can not figure out how to remove the filters. I don't want to have to recreate the document. Please help.

edit retag flag offensive close merge delete


gmaggio gravatar imagegmaggio ( 2019-11-28 18:14:57 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-08-15 17:09:41 +0100

m.a.riosv gravatar image

updated 2018-08-15 17:10:05 +0100

Go to any cell where the filter is applied, then use Menu/Data/More filters/Reset filter

edit flag offensive delete link more


The "Reset filter" is greyed out. Any ideas?

RogerRamjet gravatar imageRogerRamjet ( 2018-10-12 17:09:53 +0100 )edit

Try from the title row of the filter.

m.a.riosv gravatar imagem.a.riosv ( 2018-10-12 18:06:24 +0100 )edit

Mine is also greyed out. What do you mean by "the title row of the filter"??

gmaggio gravatar imagegmaggio ( 2019-11-28 17:45:51 +0100 )edit

answered 2020-11-25 04:25:14 +0100

lucky67 gravatar image

I know too late for this question - but just in case anyone has a similar problem. I had the reset filter greyed out too (possibly because I had closed and saved the file before I tried to remove the filter?) Anyway the way I got around it was to select the filtered column and create a random new filter, then go back to the menu and the reset filter was no longer greyed out - selected it and got the unfiltered data.

edit flag offensive delete link more


Thank you. This worked for me too. Initially the reset filter option was grayed out.

Librecalcman gravatar imageLibrecalcman ( 2021-01-09 12:30:13 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-15 15:02:43 +0100

Seen: 3,401 times

Last updated: Nov 25 '20