How to insert multiple rows in Microsoft Excel on your Mac or PC, Business Insider


caption
You can insert single or multiple rows in your Excel sheet in a few simple steps.
source
Shutterstock

Let’s say you’re working in an Excel worksheet and realize that you need to insert additional rows of data.

Luckily, Excel has a built in feature to allow users to insert multiple rows.

The process is the same, regardless of the number of rows you want to insert.

Check out the products mentioned in this article:

Microsoft Office (From $139.99 at Best Buy)

MacBook Pro (From $1,299.99 at Best Buy)

Microsoft Surface Pro X (From $999 at Best Buy)

How to insert multiple rows in Excel

1. Select the row below where you want the new rows to appear.

2. Right click on the highlighted row and select “Insert” from the list. This will insert one row above the row you initially highlighted.

Select

caption
Select “Insert.”
source
Kelly Laffey/Business Insider

3. To insert multiple rows, select the same number of rows that you want to insert. To select multiple rows hold down the “shift” key on your keyboard on a Mac or PC. For example, if you want to insert six rows, select six rows while holding the “shift” key. It doesn’t matter if the selected rows have data in them, because the new rows will be inserted above these rows as one singular group and will not be inserted above each individual row.

4. Then, right click inside the selected area and click “Insert” from the list.

5. Six new rows will appear above the selected six rows.

The new rows inserted above the selected rows.

caption
The new rows inserted above the selected rows.
source
Kelly Laffey/Business Insider



Source link