Microsoft Office Tutorials and References
In Depth Information
Copying a Range of Cells to a Nonadjacent Destination Area
Table 3 – 4 Options Available in the Paste Options Gallery
CTRL + P
Copy contents and format of source area. This option is the default.
CTRL + F
Copy formulas from the source area, but not the contents and format.
CTRL + O
Formulas & Number
Copy formulas and format for numbers and formulas of source area,
but not the contents.
Keep Source Formatting
CTRL + K
Copy contents, format, and styles of source area.
CTRL + B
Copy contents and format of source area, but not any borders.
Keep Source Column
CTRL + W
Copy contents and format of source area. Change destination column
widths to source column widths.
CTRL + T
Copy the contents and format of the source area, but transpose, or
swap, the rows and columns.
CTRL + V
Copy contents of source area, but not the formatting for formulas.
Values & Number
CTRL + A
Copy contents and format of source area for numbers or formulas, but
use format of destination area for text.
Values & Source
CTRL + E
Copy contents and formatting of source area, but not the formula.
CTRL + R
Copy format of source area, but not the contents.
CTRL + N
Copy contents and format and link cells so that a change to the cells in
source area updates the corresponding cells in destination area.
CTRL + U
Copy an image of the source area as a picture.
CTRL + I
Copy an image of the source area as a picture so that a change to the
cells in source area updates the picture in destination area.
An alternative to tapping or clicking the Paste button is to press the key.
The key completes the paste operation, removes the marquee from the source
area, and disables the Paste button so that you cannot paste the copied source area to
other destination areas. The key was not used in the previous set of steps so
that the capabilities of the Paste Options button could be discussed. The Paste Options
button does not appear on the screen when you use the key to complete the
Move It or Copy It
Contrary to popular belief,
move and copy operations
are not the same. When you
move a cell, the data in the
original location is cleared
and the format of the cell is
reset to the default. When
you copy a cell, the data
and format of the copy area
remains intact. In short, you
should copy cells to duplicate
entries and move cells to
Using Drag and Drop to Move or Copy Cells
You also can use a touch screen or the mouse to move or copy cells. First, you
select the source area and point to the border of the cell or range. You know you are
pointing to the border of the cell or range when the pointer changes to a block arrow.
To move the selected cell or cells, drag the selection to the destination area. To copy
a selection, hold down the key while dragging the selection to the destination
area. You know Excel is in Copy mode when a small plus sign appears next to the block
arrow pointer. Be sure to release the mouse button before you release the key.
Using touch or the mouse to move or copy cells is called drag and drop .