Ask Your Question
0

Is there a way to save filters

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

TJMcK 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
0

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

Comments

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

Stats

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

Seen: 15 times

Last updated: Jun 03