Google Sheets - Add Blank row after every 100 rows of data

robbertly

New Member
Joined
Oct 19, 2014
Messages
15
Hello,

Just wondering if any knows if / how this can be done in Google Sheets.

  • 10 colums of data with 1,000 rows on a Google Sheets Document
  • What forumula can I use to automatically insert one or more blank rows after every 100 data filled rows to break up the large block of data?
  • Is there a forumula and if so, where do I put the forumla, is there a vba type system in Google Sheets?
Any help appreciated.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
13,548
Office Version
  1. 365
Platform
  1. Windows
Is there a forumula and if so, where do I put the forumla, is there a vba type system in Google Sheets?
Formulas can not change or move what is already in the sheet, they can only be used to report on existing data where ever you enter them.
Google sheets uses java script instead of vba. It is possible that there are members of this forum who can write java, but you would likely have more success asking on a dedicated google sheets forum. If you do this (something known as cross posting) please remember to post a link to this thread there (and a link to that thread here).
 
Solution

Forum statistics

Threads
1,141,581
Messages
5,707,196
Members
421,497
Latest member
philipg

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top