Microsoft Office Tutorials and References

In Depth Information

**Inserting and Deleting Cells in a Worksheet**

2

•

Click Insert on the shortcut menu to

insert a new row in the worksheet

by shifting the selected row and all

rows below it down one row.

•
then enter
Margin
to enter a

new row title (Figure 3 – 15).

What is the resulting format of the

new row?

The cells in the new row inherit the

formats of the cells in the row above

them. You can change this behavior

by clicking the Insert Options

button that appears immediately

below the inserted row. Following

the insertion of a row, the Insert

Options button allows you to select

from the following options: (1) ‘Format Same As Above’; (2) ‘Format Same As Below’; and

(3) Clear Formatting. The ‘Format Same as Above’ option is the default. The Insert Options

button remains active until you begin the next Excel operation. Excel does not display the

Insert Options button if the initial row does not contain any formatted data.

Select cell A4 in the new row and

row title Margin

entered in new row

Excel inserts new row

original row 4

shifted down

one row

Figure 3 –15

3

•

Right-click row heading 7 to display

a shortcut menu and then click

Insert on the shortcut menu to insert

a new row in the worksheet.

•

Select cell A7 in the new row and

then enter
Sales Revenue for

Bonus
to enter a new row title

(Figure 3 – 16).

What would happen if cells in

the shifted rows were included in

formulas?

If the rows that shift down include

cell references in formulas located in

the worksheet, Excel automatically

would adjust the cell references in

the formulas to their new locations.

Thus, in Step 2, if a formula in the

worksheet references a cell in row 7

before the insert, then Excel adjusts

the cell reference in the formula to

row 8 after the insert.

row title Sales

Revenue for Bonus

entered in new row

Excel inserts new row

original row 7 shifted

down one row

Figure 3 –16

Other Ways

1. Insert (Home tab | Cells

group), click Insert

Sheet Rows

2. Press
CTRL
+
SHIFT
+
PLUS

SIGN
, click Entire row,

click OK button