How to insert multiple rows in Google Sheets in 2 ways, using your PC or Mac
STEFANY LUNA DE LINZY/Shutterstock
You can insert multiple rows in Google Sheets, either above or below your existing rows.
When you're working with a spreadsheet in Google Sheets, you can add rows with just a couple of clicks.
If you need to add data to the middle of a Google Sheet, you could add it at the bottom, and then re-sort your sheet to get the new entries to the right place — but it's sometimes easier to simply add new rows in the spot where you want to place the data.
Here's how to do it.
Check out the products mentioned in this article:
MacBook Pro (From $1,099.99)
Lenovo IdeaPad 130 (From $299.99)
How to insert a single row in Google Sheets
When you select a cell in Google Sheets, you can right click to add a new row.
1. Right-click on a selected cell.
2. Choose "Insert Row" from the pop-up menu.
Laura McCamy/Business Insider
Your row will be added above the cell you selected.
Notice that you don't have the option to insert multiple rows or to insert rows below the current row. Read on for instructions on how to insert more than one row.
Laura McCamy/Business Insider
How to insert multiple rows in Google Sheets
It's simple to have more control over adding rows, if you know what to do. Here are the steps to add multiple rows in Google Sheets at once.
1. Click and hold your mouse on the number to the left of the row where you want to add more rows. This will highlight the whole row.
2. Without releasing that click, drag your cursor down to highlight the number of rows you want to add. For example, if you want to add two rows, drag over the next row down to highlight two rows.
Laura McCamy/Business Insider
3. Right-click anywhere in the highlighted area. Click "Add [number] Rows" in the menu that appears. You'll have two options — to add rows above or below your current row.
Laura McCamy/Business Insider
Your new rows will appear immediately.
Related coverage from How To Do Everything: Tech:
How to add a drop-down list in Google Sheets to group and organize data in your spreadsheet
How to set a print area in Google Sheets, so you can print selected cells or sheets
How to edit Google Docs files offline, for when you're without internet or trying to eliminate online distractions
How to remove a credit card from Google Play on your Android phone
'What is Google Authenticator?': How to set up Google's two-step verification software to secure all of your Google apps
Read the original article on Business Insider
