What-If Analysis, Charting, And Working With Large Worksheets Page 16
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 152
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
2
Paste button
Home tab
•
Click the Paste button (Home tab |
Clipboard group) to copy the
values and formats of the last item
placed on the Offi ce Clipboard,
Paste button arrow
range A16:A20 in this case, to the
destination area, A2:A6 in this case
(Figure 3 – 13).
What if data already existed in the
destination area?
destination area
When you complete a copy,
range A2:A6
the values and formats in the
destination area are replaced with
Paste Options
button
the values and formats of the
source area. Any data contained
in the destination area prior to
the copy and paste is lost. If you
accidentally delete valuable data,
immediately click the Undo button
on the Quick Access Toolbar.
3
•
Press the
key to remove the
ESC
source area range
A16:A20
marquee from the source area and
disable the Paste button (Home tab |
Clipboard group).
Figure 3 –13
Other Ways
1. Right-click source area, click
while holding down
CTRL
Copy on shortcut menu,
key, drag source area to
right-click destination
destination area
area, click Paste icon on
3. Select source area, press
shortcut menu
+
,
select destination
CTRL
C
+
2. Select source area and
area, press
CTRL
V
point on border of range;
Q&As
Using the Paste Options Menu
For a complete list of the
Q&As found in many of
After you click the Paste button, Excel immediately displays the Paste Options
the step-by-step sequences
button, as shown in Figure 3 – 13. If you click the Paste Options button arrow and
in this book, visit the Excel
select an option on the Paste Options gallery, Excel modifi es the most recent paste
2010 Q&A Web page
operation based on your selection. Table 3– 4 summarizes the options available on the
( ).
Paste Options gallery. When the Paste Options button is visible, you can use shortcut
keys to access the paste commands available in the Paste Options gallery. Additionally,
you can use combinations of the options in the Paste Options gallery to customize your
paste operation. That is, after clicking one of the icons in the Paste Options gallery,
you can open the gallery again to further adjust your paste operation. The Paste button
(Home tab | Clipboard group) includes an arrow that, when clicked, displays the same
options as does the Paste Options button arrow.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education