How do you add multiple rows instead of manually adding one row at a time?

[utsabnov]

How do you add multiple rows instead of manually adding one row at a time?

The Google Workspace Support team suggested automating this process using the 'App Script' add-on from the Google Workspace Marketplace.

There should be an easy way like Excel but for Google Sheets.

[henrya]

I'm not sure if you are looking to simply add empty rows to a sheet. If that's the case, then scroll to the bottom of the sheet, specify how many rows you want to add and click the blue Add button. But if you are looking to automatically add rows based on a certain action, then appscript would be your best bet.

Otherwise, give us more details of your situation so we can provide specifit solution.

[utsabnov]

Let's say I want to add 10 rows between existing data. I can only add one row above and one row below.

[Kumasekaran · Accepted solution]

To add multiple rows, first select the number of rows you want to insert, then right-click. You can choose to insert them above or below the selected rows.