View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Excel 2002 - How to keep the formulas unchanged ?

Try this format:
=$C$1-$B$1

Regards,
Stefi

"Mr. Low" wrote:

Dear Sir,

May I know how to keep the formula in a cell at its stationary position when
the other cell is moved ?

Lets consider the folowing worksheet example:

A B C D
1 = C1-B1
2 = C2-B2
3 = C3-B3
4

Formula =(C1-B1) is entered cell A1, however when cell C1 is cut and moved
to position C2, the formula in cell A1 now becomes = (C2-B1).

Is there a way to keep the formula in column A remain unchanged even if
column C is moved out from its original position (i.e. up, down, lefft or
right) ?


Thanks

Low


--
A36B58K641