Microsoft Office Tutorials and References
In Depth Information
Copying a Range of Cells to a Nonadjacent Destination Area
• Tap or click the Paste button (HOME tab | Clipboard group) to copy the values and formats of the last item placed
on the office Clipboard, range A9:A13 in this case, to the destination area, A19:A23 in this case. If necessary, scroll
down to see the complete destination area (Figure 3 – 13).
Figure 3 – 13
What if data already existed in the destination area?
When you complete a copy, the values and formats in the destination area are replaced with 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 tap or click the Undo button on the Quick Access Toolbar or press CTRL + Z .
• Press the ESC key to remove the marquee from the source area and disable the Paste button (HOME tab | Clipboard group).
1. Press and hold source area and tap ‘Show Context
Menu’ button on mini toolbar or right-click source
area, tap or click Copy on shortcut menu, press
and hold or right-click destination area, tap or
click Paste icon on shortcut menu
3. Select source area, press CTRL + C ,
select destination area, press CTRL + V
2. Select source area and point to border of
range; while holding down CTRL key, drag
source area to destination area
Using the Paste Options Menu
After you tap or click the Paste button, Excel immediately displays the Paste
Options button, as shown in Figure 3 – 13. If you tap or click the Paste Options arrow
and select an option in the Paste Options gallery, Excel modies the most recent paste
operation based on your selection. Table 3 – 4 summarizes the options available in the
Paste Options gallery. When the Paste Options button is visible, you can use keyboard
shortcuts 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 tapping or clicking one of the icons in
the Paste Options gallery, you can display the gallery again to further adjust your paste
operation. The Paste button (HOME tab | Clipboard group) includes an arrow that,
when tapped or clicked, displays the same options as the Paste Options button.
Copying and Pasting
from Other Programs
If you need data in Excel that
is stored in another program,
copying and pasting likely
will help you. You might
need to experiment before
you are successful, because
Excel might attempt to
copy formatting or other
information that you did not
intend to paste from the other
program. Using the various
Paste Option buttons likely will
solve most of such problems.