Click a table cell in the row above or below where you want the new row to appear. On the Layout tab, in the Rows & Columns group, do one of the following: To add a row above the selected cell, click Insert Above. To add a row below the selected cell, click Insert Below.
- When you insert a new row will the row be added above or below the selected cell's )? Above below?
- How do you insert a row above or below?
- Which option will insert a new blank row above the selected row?
When you insert a new row will the row be added above or below the selected cell's )? Above below?
Insert a cell and move the existing cells down one row. A new row is added at the bottom of the table. Insert a row above the cell that you clicked in. Insert a column to the left of the cell that you clicked in.
How do you insert a row above or below?
To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones. Right-click the selection, and then select Insert Rows.
Which option will insert a new blank row above the selected row?
Luckily, there is an easy keyboard shortcut for this: Ctrl+Shift+Plus. Simply click a row number to select a row, hold down the Ctrl and Shift keys, and press plus (+). Excel will then add a row above the selected row.