Menu:

Paste Special

You may only want to copy a border, a cell format or the cell value from one cell to another. Rather than copying all characteristics of that cell.
To do this, you can copy then Paste Special.

1. First control C on the cell you wish to copy.
2. Then click on Edit, Paste Special per the diagram below: 

3. You can now select whether you want to paste special values, formulas etc.

Copyright © 2008 Excel Help