Microsoft Office Tutorials and References
In Depth Information
Copying a Range of Cells to a Nonadjacent Destination Area
Copying and Pasting
from Other Programs
If you have data you
need in Excel, but the
data 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 buttons
likely will solve most of
Table 3 – 4 Options Available in the Paste Options Gallery
CTRL + P
Copy contents and format of source area. This option is
CTRL + F
Copy formulas from the source area, but not the
contents and format.
Formulas & Number
CTRL + O
Copy formulas and format for numbers and formulas
of source area, but not the contents.
CTRL + K
Copy contents, format, and styles of source area.
CTRL + B
Copy contents and format of source area, but not any
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
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
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 clicking the Paste button is to press the enter key. The enter 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 enter 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 enter key to complete the paste operation.
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 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 mouse 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
ctrl 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 mouse pointer. Be sure to
release the mouse button before you release the ctrl key. Using the mouse to move or
copy cells is called drag and drop .