Re: Insert $ to make address absolute

From: Roger Govier (roger_at_technologyNOSPAM4u.co.uk)
Date: 03/04/05 

Date: Fri, 4 Mar 2005 06:53:48 -0000

You can place the $ sign where you wish in a formula as you type it.
Alternatively, whilst your cursor is on A1 for example, if you press the F4
function button, Excel will make the entry $A$1.

Subsequent pressing of F4 will cycle the address through A$1, $A1 and back
to A1 again 

-- 
Regards
Roger Govier
"Tenacity" <Tenacity@discussions.microsoft.com> wrote in message 
news:2B944B7D-4E14-43F4-B04F-F9DB4D354AFC@microsoft.com...
> Is there a function or macro which will automatically take an existing
> function, say, SUM(A1..B99) and make it SUM($A1..B99) or SUM(A$1..$B99),
> etc.?  How can you isolate on the one part of the address you want to add 
> the
> $ to?
>
> Thanks for your help.