How to Insert Multiple Rows
in Google Sheets

Open your Google Sheets document and select the row where you want to insert new rows.

Right-click on the row number where the new rows should be inserted.

In the context menu, select "Insert X rows above" or "Insert X rows below," depending on where you want the new rows to appear.

If you want to insert multiple rows, select more than one row before right-clicking, then choose the number of rows to insert.

Google Sheets will automatically insert the new rows in the selected position, shifting existing data down.

To adjust the data in the new rows, simply click on the cells and input your information as needed.