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

[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.

 

[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.

 

[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

 

[Dave Peterson]

You want to duplicate the exact formula???

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