This wikiHow teaches you how to insert multiple rows at once in a Google Sheets website on a computer.
Step
![Insert Multiple Rows on Google Sheets on PC or Mac Step 1 Insert Multiple Rows on Google Sheets on PC or Mac Step 1](https://i.how-what-advice.com/images/008/image-21483-1-j.webp)
Step 1. Launch a web browser and visit
If you have logged in using a Google account, a list of Google Sheet documents related to your account will be opened.
If you're not automatically signed in, sign in to your Google account first
![Insert Multiple Rows on Google Sheets on PC or Mac Step 2 Insert Multiple Rows on Google Sheets on PC or Mac Step 2](https://i.how-what-advice.com/images/008/image-21483-2-j.webp)
Step 2. Click the Google Sheet document you want to open
-
You can also create a new Google Sheet document by clicking
![Insert Multiple Rows on Google Sheets on PC or Mac Step 3 Insert Multiple Rows on Google Sheets on PC or Mac Step 3](https://i.how-what-advice.com/images/008/image-21483-4-j.webp)
Step 3. Select the row below or above where you want to add a row
Select the row by clicking the number in the gray column on the left.
![Insert Multiple Rows on Google Sheets on PC or Mac Step 4 Insert Multiple Rows on Google Sheets on PC or Mac Step 4](https://i.how-what-advice.com/images/008/image-21483-5-j.webp)
Step 4. Hold down Shift and specify the number of rows you want to add
For example, if you want to add 4 new rows, select 4 rows below or above where you want to add additional rows.
![Insert Multiple Rows on Google Sheets on PC or Mac Step 5 Insert Multiple Rows on Google Sheets on PC or Mac Step 5](https://i.how-what-advice.com/images/008/image-21483-6-j.webp)
Step 5. Right-click the row you selected
Right-click all highlighted (selected) rows. A drop-down menu will open.
On Mac computers, you can click the trackpad or magic mouse with two fingers. You can also press and hold the Control key while clicking
![Insert Multiple Rows on Google Sheets on PC or Mac Step 6 Insert Multiple Rows on Google Sheets on PC or Mac Step 6](https://i.how-what-advice.com/images/008/image-21483-7-j.webp)
Step 6. Click Insert # rows above or Insert # rows below.
Sign # is the number of selected rows. By doing so, multiple new rows will be inserted below or above the row you selected.