Excel 2007 : hide series of rows

[revelator]

I have a very large data file, with almost 3,000 rows. Only the first of every 4 rows of data are useful. I need to hide every 2nd, 3rd, and 4th row, and retain the 1st, 5th, 9th, etc. rows. What is the best/easiest way to do this?

[JieJenn]

Alt + F11 to open the visual basic window, insert a new module, copy paste the code and hit F5 to run it

Change 100 to your last row #

Please Login or Register  to view this content.

[revelator]

Worked great - Thanks!

I have a column of numerical values (ie. 5250 cfm, 5500 cfm, etc) that I need to remove the text (cfm) from, so that I can cumulatively add the numbers.

I also want to show:

5250 cfm
5500 cfm (this Box to show lines 1+2 (5250 & 5500) added together)
5700 cfm (this box to show line 1+2+3 added together
5900 cfm (this box to show line 1+2+3+4 added together, and so on

Thanks