Mark lines for future filter.

[sabrefan1970]

Is it possible to, as I scroll by hand thru a sheet (several thousand lines ) to mark lines of interest as I go to filter for them later ? Then easily unmark them ?

[maniacb]

You can always create a column to track rows by entering say the value 1 and then use data filter to find those rows

[Croweater]

Or if you just want to 'scroll and click'

Please Login or Register  to view this content.

[sabrefan1970]

Thanks for the suggestion. Future designs will incorporate a "selection" column as you suggest, but for various reasons this implementation for the existing sheet will be a last resort.