Google Sheets - how to insert row(s) into multiple tabs within same sheet?

Viewed 4047

I have a Google Sheet with 20+ tabs.

Is it possible to perform the "Insert -> Row Above" command on multiple tabs?

I know it can be done in Excel (Group Tabs, Insert, Ungroup), but I don't see any way to group tabs in Sheets.

I can do it manually, i.e. Insert->Row Above, click next tab, Insert->Row Above, click next tab, etc - but that's tedious, annoying, and error-prone.

So, is there a command to insert row and replicate that action across all tabs in a sheet? Or is it possible to write a script for this?

1 Answers
Related