Ask Your Question

Is there a way to save filters

asked 2019-06-03 21:42:02 +0200

TJMcK gravatar image

updated 2020-07-20 10:16:10 +0200

Alex Kemp gravatar image

I am constantly using autofilter in calc. I spend a huge amount of time setting up complex filters (with autofilter), and then it's lost. Is there a way to save filters with descriptions?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-06-03 23:18:49 +0200

m.a.riosv gravatar image

You can use Advanced filters, give a name to the range where each filter is defined, marking as filter when named range is set up, and select it on the advanced filter box.

edit flag offensive delete link more


Unfortunately, I can't get this advanced filter to work. When I select a partial sheet ($SUMMARY.$A$1:$Y$7533) it takes about 10 min until the process completes and the advanced filter dialogue closes. It appears the save process does not complete because there is no saved filter.

TJMcK gravatar imageTJMcK ( 2019-06-15 05:10:44 +0200 )edit

Please edit you question and attach a sample file to test.

m.a.riosv gravatar imagem.a.riosv ( 2019-06-15 10:18:17 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-03 21:42:02 +0200

Seen: 414 times

Last updated: Jun 03 '19