Multiple AutoFilters

asked 2018-12-25 12:35:06 +0100

alex72gr gravatar image

Hello! 1) In my spreadsheet I have created an autofilter including multiple columns. Each column has it's own "filter" (header cell). The problem is that when I try to select another "region" of the spreadsheet and create another autofilter, the first autofilter disappears! Is there ANY way to keep both autofilters? 2) The second autofilter I need to create would be by far more flexible if I could create JUST ONE header cell for the selected "region" of my spreadsheet (this "region" is actually a "range" of cells which includes many columns). So, what I need is a single header cell where from I could select ANY of the values of the above mentioned "region" of my spreadsheet. Is this possible? Thanks a lot!

edit retag flag offensive close merge delete


You need to define a data range for the area to which you want to apply a filter.

Regina gravatar imageRegina ( 2018-12-25 13:12:52 +0100 )edit

I do so when I apply a filter. Otherwise the filter will not work at all. The problem is 1) adding a new filter (for example a filter on another column) and 2) filter data from an area from one single header cell. Thank you anyway! :)

alex72gr gravatar imagealex72gr ( 2018-12-25 21:45:19 +0100 )edit

Menu/Data/Define range

m.a.riosv gravatar imagem.a.riosv ( 2018-12-25 23:58:44 +0100 )edit