This guide was created with Scribe in 19 seconds. Sign in and create your own!
How to insert a lot of rows into Google Sheets
Lindsey Bly |
0 step |
19 seconds
This guide will show you how to insert a single row or multiple rows into a Google Sheet.
1
Navigate to your Google Sheet.
2
Click here.
Zoom Saved
3
Click on the row number to highlight the whole row.
Zoom Saved
4
Click "Insert 1 row above" to add a single row.
Zoom Saved
5
To add multiple rows at once, click the row number
Zoom Saved
6
Scroll down to the number of rows you want to add and click on that row number. For example, if you're starting at Row 7 and want to add 44 rows, scroll down to row 50.
Zoom Saved
7
Click on that row number. Google Sheets will highlight all the rows in between those two numbers
Zoom Saved
8
Click "Insert X rows above".
Zoom Saved
9
Google sheets will automatically add in new rows.
Zoom Saved
Was this Scribe helpful? Save this document for future reference.
Save for Later
Have something to say?Create an account to leave messages for the author to see!Create an account
Feedback
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe