Forum Discussion
Hiding rows in an excel
I am looking for any suggestion on a quick way to hide multiple rows in and excel spread sheet. I have logged approximately 16000 lines of data and I need to hide 9 rows, keep the 10th row visible, ...
Hi David70
You can use this approach:
Insert a column where you type a letter, e.g "a" in rows 1 to 9 and something else in row 10, e.g leave blank. Then drag these data all the way down. Then use filter to select only the blank cells.
See attached document for guidance.
I hope this will be useful
Cheers
David70 As a variant, I attach a solution with the FILTER function that does not require a helper column. Furthermore, it automatically detects the used range in the numbers column (A in the attached example). One single formula in F1 returns a dynamic table of all 10th rows from the original data.
Depending on your Excel version, though, FILTER might not (yet) be supported.
=FILTER($A$1:INDEX($D:$D,MATCH(99^99,$A:$A)),MOD(ROW($A$1:INDEX($A:$A,MATCH(99^99,$A:$A))),10)=0)
