Hiding Rows by odd or even numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-2303678%22%20slang%3D%22en-US%22%3EHiding%20Rows%20by%20odd%20or%20even%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2303678%22%20slang%3D%22en-US%22%3E%3CP%3Eis%20there%20a%20way%20to%20select%2Fhide%26nbsp%3BRows%20by%20odd%20or%20even%20numbers%3F%3C%2FP%3E%3CP%3Einstead%20of%20picking%20each%20Row%20separately%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2303678%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2303824%22%20slang%3D%22en-US%22%3ERe%3A%20Hiding%20Rows%20by%20odd%20or%20even%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2303824%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1039830%22%20target%3D%22_blank%22%3E%40John39%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20could%20populate%20an%20unused%20column%20with%20formulas%20%3DISODD(ROW())%3C%2FP%3E%0A%3CP%3EYou%20can%20then%20filter%20for%20TRUE%20to%20see%20the%20odd-numbered%20rows%20and%20hide%20the%20even-numbered%20ones%2C%20or%20for%20FALSE%20to%20do%20the%20reverse.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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