Ask Your Question

How do I save my advanced filter to a new list?

asked 2019-08-12 17:09:06 +0200

Avey Franklin gravatar image

updated 2020-08-18 13:22:32 +0200

Alex Kemp gravatar image

I have created several Advanced Filters in a large spreadsheet and I would like to have the filters added to the "Read Filter Criteria From" list shown in image below. For example, I would like "filter1, filter2, ..." added to the list. Currently, the list displays only "Undefined" and I cannot find a means of adding new items to the list. Thanks!
image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-08-12 17:21:54 +0200

erAck gravatar image

Assign a criteria cell range a name (Sheet -> Named Ranges and Expressions -> Define (or Manage, or Ctrl+F3)) and there under Range Options activate Filter for that range.

edit flag offensive delete link more


Thank you - works great!!! I never would have figured this out :-)

Avey Franklin gravatar imageAvey Franklin ( 2019-08-12 18:59:56 +0200 )edit

Glad to help. Then please mark the answer as correct by clicking the check mark icon.

erAck gravatar imageerAck ( 2019-08-13 16:09:08 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-12 17:09:06 +0200

Seen: 119 times

Last updated: Aug 12 '19