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
 
Search JabSto ::




Custom Search