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, then repeat this step through to the end. Any suggestions would be greatly appreciated.
5 Replies
As a possible refinement to the suggesion wumolad made--and I do emphasize "possible"--there must be some feature of that ninth row, the one that you want to hid, that is distinctive, so perhaps you don't even need to add a column, if that distinctive feature itself could be the basis for the filtering.
As I said, a possible refinement.
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)
