How do I copy a cell and do a paste without changing coordinates?

J

Joel

tWhen I copy the contents of a cell and paste it elsewhere the coordinates of
the cell change and the wrong data is pasted into the cell. Please explain
what I am doing wrong.
Thanx.
 
S

Steved

Hello Joel

One Way

1. Select the cell you want to copy, then Edit,Copy
2. Select the cell you want to paste to, then Edit, Paste
Special, Value and Ok.
 
C

Cutter

Do you mean Absolute versus Relative referencing? What you describ
indicates you used relative referencing.

Example:
In B1 you have formula: =A1

If you copy that formula and paste it in B2 you would have it change t
=A2

But if you type in B1: =$A$1

you can copy and paste that formula anywhere and it would always equa
the contents of A
 
D

Dave Peterson

You want to duplicate the exact formula???

Copy from the formula bar and paste into the formula bar.
 
Top