What-If Analysis, Charting, And Working With Large Worksheets Page 19
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87What-If Analysis, Charting, and Working with Large Worksheets
Excel Chapter 3
EX 155
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.
•
Select cell A4 in the new row and
Margin
then enter
to enter a
new row title (Figure 3– 15).
What is the resulting format of the
row title Margin
new row?
entered in new row
The cells in the new row inherit the
Excel inserts new row
formats of the cells in the row above
them. You can change this behavior
by clicking the Insert Options
original row 4
shifted down
button that appears immediately
one row
below the inserted row. Following
the insertion of a row, the Insert
Figure 3 –15
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.
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
Sales Revenue for
then enter
Bonus
to enter a new row title
(Figure 3 –16).
What would happen if cells in
the shifted rows were included in
row title Sales
formulas?
Revenue for Bonus
entered in new row
If the rows that shift down include
cell references in formulas located in
Excel inserts new row
the worksheet, Excel automatically
would adjust the cell references in
the formulas to their new locations.
original row 7 shifted
down one row
Thus, in Step 2, if a formula in the
worksheet references a cell in row 7
Figure 3 – 16
before the insert, then Excel adjusts
the cell reference in the formula to
row 8 after the insert.
Other Ways
1. Insert (Home tab | Cells
group), click Insert
Sheet Rows
+
+
2. Press
CTRL
SHIFT
PLUS
, click Entire row,
SIGN
click OK button
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education