More than 5 years have passed since last update.

GASで１行おきに行を挿入するスクリプト

GoogleAppsScript

Last updated at 2019-06-24Posted at 2019-06-24

function insert() {
  var objSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var objSheet = objSpreadsheet.getActiveSheet();

  var i=10 // 10行目から始める
  for(i; i>0; i--){
  objSheet.insertRowAfter(i);
  }
};

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up