How do I delete filters created

calc

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

Mary M
1 ●1 ●1 ●1

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

Comments

Try this: https://forum.openoffice.org/en/forum...

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

add a comment

0

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

m.a.riosv

25719 ●7 ●53 ●139

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

Comments

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

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

Try from the title row of the filter.

m.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 ( 2019-11-28 17:45:51 +0100 )edit

add a comment

0

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

lucky67
47 ●10 ●12 ●20

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

Comments

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

Librecalcman ( 2021-01-09 12:30:13 +0100 )edit

add a comment

How do I delete filters created

Comments

2 Answers

Comments

Comments

Question Tools

Stats

Related questions

How do I delete filters created edit

Comments

2 Answers

Comments

Comments

Question Tools

Stats

Related questions

How do I delete filters created