A simple way to change several cell refs to absolute ?

[Guest]

Hi

If I have a formula containing three or more cell references
e.g. A1*A2/A3

I am aware that if I use F4 I can one cell at a time change each cell
reference to absolute.
This can be rather tedious if there are many more cell references in a
formula and there are several similar formulae in a worksheet.

Does any one have any ideas ?

 

[RagDyeR]

Select the *entire* formula in the formula bar, and then use <F4>!

Changes *all* cell references at the same time.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hi

If I have a formula containing three or more cell references
e.g. A1*A2/A3

I am aware that if I use F4 I can one cell at a time change each cell
reference to absolute.
This can be rather tedious if there are many more cell references in a
formula and there are several similar formulae in a worksheet.

Does any one have any ideas ?

 

[Guest]

Hi,
Try downloading an addin from "asap utilities" (google for it) it does all
sorts of wonderful things for excel that excel cannot do for itself.

 

[Guest]

RD

Thanks it works

Jay

 

[Guest]

Thanks I have put the URL in my favourites.

Jay

Hi,
Try downloading an addin from "asap utilities" (google for it) it does all
sorts of wonderful things for excel that excel cannot do for itself.

 

[Ragdyer]

Appreciate the feed-back.

 

[Ray]

Or, even easier , check out this solution:
http://www.asap-utilities.com/

LOTS of goodies ...!

ray