Lock individual cell references in a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need someone to remind me how to lock the referenced cells in a formula (so that they will not be relative if moved). I believe there is a short cut key for that? Any additional ways to switch them on and off? It would be great to know. For example if the formula is =A1+B1 and I wanted to quickly change it to =$A$1+$B$1 or even =$A1+$B1 or =A$1+B$1.
Thank you.
 
F2 or double click into the cell, then on each part of the formula use F4 to
toggle through the various iterations.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



David P. said:
I need someone to remind me how to lock the referenced cells in a formula (so
Click to expand...
that they will not be relative if moved). I believe there is a short cut key for
that? Any additional ways to switch them on and off? It would be great to know.
For example if the formula is =A1+B1 and I wanted to quickly change it to
=$A$1+$B$1 or even =$A1+$B1 or =A$1+B$1.
 
David
Hit the F4 key to toggle through the reference styles. For your example you could sweep the formula in the formula bar and both reference will toggle at the same time

Good Luck
Mark Graesse
(e-mail address removed)

----- David P. wrote: ----

I need someone to remind me how to lock the referenced cells in a formula (so that they will not be relative if moved). I believe there is a short cut key for that? Any additional ways to switch them on and off? It would be great to know. For example if the formula is =A1+B1 and I wanted to quickly change it to =$A$1+$B$1 or even =$A1+$B1 or =A$1+B$1.
Thank you.
 
Back
Top