Hiding Rows by odd or even numbers

Copper Contributor

is there a way to select/hide Rows by odd or even numbers?

instead of picking each Row separately

2 Replies

@John39 

You could populate an unused column with formulas =ISODD(ROW())

You can then filter for TRUE to see the odd-numbered rows and hide the even-numbered ones, or for FALSE to do the reverse.

THANK THIS IS EXACTLY WHAT I NEEDED@Hans Vogelaar