What-If Analysis, Charting, And Working With Large Worksheets Page 18
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
87EX 154
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
Cutting
Using Cut and Paste to Move Cells
When you cut a cell or
range of cells using the Cut
Another way to move cells is to select them, click the Cut button (Home tab |
command on a shortcut
Clipboard group) (Figure 3– 12 on page EX 151) to remove them from the worksheet and
menu or Cut button (Home
copy them to the Offi ce Clipboard, select the destination area, and then click the Paste
tab | Clipboard group), Excel
button (Home tab | Clipboard group) or press the enter key. You also can use the Cut
copies the cells to the Offi ce
command on the shortcut menu, instead of the Cut button.
Clipboard, but does not
remove the cells from the
source area until you paste
the cells in the destination
area by either clicking
Inserting and Deleting Cells in a Worksheet
the Paste button (Home
tab | Clipboard group) or
pressing the
key.
At any time while the worksheet is on the screen, you can insert cells to enter new data or
ENTER
When you complete the
delete cells to remove unwanted data. You can insert or delete individual cells; a range of
paste, Excel clears the cell’s
cells, rows, columns; or entire worksheets.
or range of cell’s entries
and their formats from the
source area.
To Insert a Row
According to the sketch of the worksheet in Figure 3 –3a on page EX 142, two rows must be inserted in the
What-If Assumptions table, one between Commission and Marketing for the Margin assumption and another
between Research and Development and Support, General, and Administrative for the Sales Revenue for Bonus
assumption. The following steps insert the new rows into the worksheet.
1
•
Right-click row
heading 4, the row
below where you
want to insert a row,
to display the shortcut
menu and the Mini
toolbar (Figure 3– 14).
Mini toolbar
row heading 4
shortcut menu
Insert command
Figure 3 – 14
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education