making one cell equal another cell and having the pointer stay fix

H

Hank

I want to make one cell equal another cell. For example I want cell A1 to
equal cell B1. In cell A1 I type '=B1'. Then I enter a value in B1 and I
see the value I typed in A1. But when I moved the value in B1 to another
cell, the formula in A1 automatically changes to point at the cell that I
moved the contents in B1 to. Is there any way I can prevent this?

thanks
Hank
 
T

tghcogo

Hi Hank

I t depends on what you are trying to achieve.

If you no longer need the cells in column A to dynamically change th
simple solution is to highlight column A, "copy" "paste special"
value. "

hope this helps

TGHCOG
 
Top