Select the relevant cell references in the formula bar and press
F4 to cycle through the various reference styles.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"David P." <DavidP@discussions.microsoft.com> wrote in message
news:19A4BCF7-04BE-4F1E-B551-4D748DAB9B1D@microsoft.com...
> Are there any tricks (control or alt + something for example)
> to locking or
> unlocking (probably not using the correct terms) of cell
> references in a
> formula in order to set it up for the autofill scenario I want
> to do? For
> example if I have the following formula:
>
> =a1+b1
>
> How can I easily change it to =$a$1+$b$1
> or =a$1+b$1
> or =$a1+$b1
>
> I may just be crazy, but if you have any quicker command button
> suggestions
> to change these scenarios easier than having to type them every
> time that
> would be great. Thank you.
> --
> David P.