|
In
excel data can be copy and pasted to different
areas of the worksheet just as with other office
applications. There are a range of special options
that allow you to selectively filter what you paste
into a destination.
By
default excel copies all data, labels, formula,
comments and formatting and pastes it into the
destination cells.
To
copy a group of cells, simply highlight the cell
or range of cells that you want to copy, right
click on the selection and choose copy. When you
see the “marching ants”
highlighting it tells you that the information
has been successfully copied to the clipboard.
Cells
have multiple forms of content and formatting
can be copied on the clipboard but settings
can be changed so that only specific attributes
are pasted into the destination.
For
example formulas can be copied but the paste
setting can be modified so that only the
displayed values related to that equation
are pasted into the new location.
To
do this copy the cells as normal then right
click on the destination cell and select paste
special. In the paste special dialogue
box select the
“Values” radio button
and press the “OK”
button.
|
|
Fig
1.3 Image of the paste special dialogue
box |
Copy
and paste a table of values
Keeping
source formatting |
