Applying Filter to All Rows

[jcountry22]

i have a large worksheet that I want to apply a Filter in Row 1 across all columns that will show me all data in each row for any given column.

I have a data set from Row 6-42, that are grouped

then another data set from row 48-50, that are grouped

and so on throughout the worksheet down to row 600+

i copied this worksheet from a prior tab i had that contained the filter. however after restructuring the worksheet, i had to unapply the filter. Now when i go to put it back in row 1, it just shows a square "Select All", but no options.

is it possible to get this applied again ??

 

[jmacleary]

Hi there. It sounds like row 2 of your sheet is blank? If so, then all you need to do is take the filter off, select all the columns and reapply the filter.