Microsoft Excel 2007 tutorial: insert rows on a worksheet


Insert rows on a worksheet

XVIII. Insert rows on a worksheet

You can insert a row, multiple rows, and nonadjacent rows on a worksheet. When you add rows to the worksheet, Excel normally inserts the rows above the selected rows. To insert a row, multiple rows, and nonadjacent rows, follow the procedure below.

XVIII.1. Insert a row

- Select any row

- Right-click the selected row, and then click Insert on the shortcut menu.

Excel 2007 insert a row

Or

- Select the row

- On the Home tab, in the Cells group, click Insert or click drop-down arrow next to Insert, and then click Insert Sheet Rows. You can also click Insert Cells to add a new row.

 Excel 2007 insert a row by using Insert tool

Excel adds a row above the selected row immediately.

You can repeat the action of inserting a row quickly by selecting the location where you want to insert the row, and then press Ctrl +Y.

XVIII.2. Insert multiple rows

- Select the number of rows

- Right-click the selected rows, and then click Insert.

Excel 2007 insert multiple rows

Or

- Select the rows

- On the Home tab, in the Cells group, click Insert or click drop-down arrow next to Insert, and then click Insert Sheet Rows or Insert Cells.

Excel adds the rows above the selected rows immediately.

For example, in your worksheet, there is one row data as the figure:

Excel 2007 worksheet contains one row data

As you see on the figure, there are three blank rows above a row data. Now, you want to add more five rows above the row data. To do this task, follow the procedure below:

1. Select five rows start from the first row to the fifth row or from the fifth row up to the first row.

2. Right-click the selected rows

3. Click Insert on the shortcut menu

Excel 2007 select five rows

or

1. Follow step one by selecting the five rows

2. On the the Home tab, in the Cells group, click Insert or click drop-down arrow next to Insert, and then click Insert Sheet Rows or Insert Cells.

Excel adds five rows to the worksheet above the row data; so the row data moves down to the ninth row while its prior location is on the fourth row. Totally, there are eight rows above the row data.

Excel 2007 add five rows

XVIII.3. Insert nonadjacent rows

- Select nonadjacent rows

- Right-click the nonadjacent rows

- Click Insert on the shortcut menu.

Or

- After selecting the nonadjacent rows

- On the Home tab, in the Cells group, click Insert or click drop-down arrow next to Insert, and then click Insert Sheet Rows or Insert Cells.

For example, you want to add nonadjacent rows to the fifth row and third row of the worksheet below.

Excel 2007 worksheet example of nonadjacent rows

To do this task, follow the procedure below:

1. Select the first and third rows

2. Right-click the selected rows

3. Click Insert on the shortcut menu.

Excel 2007 select nonadjacent rows

or

1. Follow step one by selecting nonadjacent rows (row one and row three)

2. On the Home tab, in the Cells group, click Insert or click drop-down arrow next to Insert, and then click Insert Sheet Rows or Insert Cells.

Excel adds nonadjacent rows above the first and third rows; so the first row moves to the second row and the third row moves to the fifth row.

Excel 2007 add nonadjacent rows


Comments





This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.