Moving formulas without entering reference ($)

[Smidt57]

Hi

I have a long formula; like
=H20+H21+H22+H23+J13+H21+J14+J16+K2 (plus 80 more)

I will copy this to another cell, without entering absolute reference '$' in
the formula, so the formula is the same in the new cell. Is there a way to do
this in Excel 2003?

 

[Govind]

Hi,

There is a simple way to do it.

Press F2(cell edit) in the cell where you have the formula. Copy the
formula contents and paste it in the cell where you want.

Regards

Govind

 

[Niek Otten]

You'll have to remove the "=" sign before pasting. After pasting, re-insert
the "=".

 

[Gord Dibben]

To do 81 at a whack I would suggest....

Edit>Replace

What: =
With: xxx

Replace all.

Copy/move the formulas then reverse the Edit>Replace.

Gord Dibben Excel MVP