Insert Blank Row Every 30 Rows

I recently got a data file with a LOAD of information, reading it is becoming a strain as i always lose track of where i am

I would like to insert/create a new row for every 30.


How can I get this done?

You can use VBA for this...

Please Login or Register  to view this content.

Paste code in a Normal module

• Where to paste code
• Highlight macro to copy >> Ctrl + C >> Open your workbook
• Alt + F11 >> opens the Visual Basic Editor (VBE)
• Ctrl + R >>opens the Project Explorer (if not already open on left side of screen)
• Insert menu >> Module or Alt + I, M >> activates the Insert menu and inserts a Standard Module
• Paste code >> Ctrl + V (right side of screen)
• Alt + Q >> exits VBE and returns to Excel
• Back in Excel >> Alt + F8 >> Macro Dialog Box >> Highlight macro >> Run

hi anonymust, here's a non-VBA approach if you need one. place a formula in another column.
this is for rows 30, 60, 90 & so on.
=MOD(ROW(),30)=0
this is for data that makes up 30, 60, 90 & so on. that means your data may start from A8 & 30 rows later is A37. change the one in red to where you start
=MOD(COUNTA(A$1:A1),30)=0

after this, do an Autofilter & select those that are TRUE. select those rows & press ALT + ; to select visible cells. then Home -> Insert -> Insert Sheet Rows