HOw do I change group of cells from absolute reference?

  • Thread starter Thread starter bre
  • Start date Start date
B

bre

When I do a Paste Special>Paste Link, the cell looks something lik
='MAIN'!$A$3. This is great, its just what I want. Now I remove the
beofre the 3 and drag the cells so my list is linked correctly, like
='MAIN'!$A3, ='MAIN'!$A4, ='MAIN'!$A5, and so on. If I don't remove th
$, it just stays as $A$3 for every item.

Here's my question. Is there and easy way to convert the cells back t
being locked with the $ in place again like: ='MAIN'!$A$3
='MAIN'!$A$4, ='MAIN'!$A$5, and so on? Sometimes the list is long an
its a pain putting those $ back again. I seem to remember some kind o
toggle that would turn absolute ref on and off.

I guess that my question. Is there some way usinf the keyboard to tur
a cell into absolute referencing and back again? Thanks
 
Highlighting the address in the formula bar, then hitting F4 will toggle between
all the absolute/relative possibilities.

$a$1
$a1
a$1
a1
 
Back
Top