HOw do I change group of cells from absolute reference?

When I do a Paste Special>Paste Link, the cell looks something like ='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 the $, it just stays as $A$3 for every item.

Here's my question. Is there and easy way to convert the cells back to 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 and its a pain putting those $ back again. I seem to remember some kind of toggle that would turn absolute ref on and off.

I guess that my question. Is there some way usinf the keyboard to turn 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



bre wrote:
>
> When I do a Paste Special>Paste Link, the cell looks something like
> ='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 the
> $, it just stays as $A$3 for every item.
>
> Here's my question. Is there and easy way to convert the cells back to
> 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 and
> its a pain putting those $ back again. I seem to remember some kind of
> toggle that would turn absolute ref on and off.
>
> I guess that my question. Is there some way usinf the keyboard to turn
> a cell into absolute referencing and back again? Thanks.
>
> --
> bre
> ------------------------------------------------------------------------
> bre's Profile: http://www.excelforum.com/member.php...o&userid=20765
> View this thread: http://www.excelforum.com/showthread...hreadid=470485

--

Dave Peterson

THanks. Guess that's where I saw the toggle thing. Is there a way to do a range of cells?

You could have a macro do it.

Gord Dibben recently posted this:

http://groups.google.co.uk/group/mic...c824e9ba8ce2f7

or

http://snipurl.com/hx8y

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

bre wrote:
>
> THanks. Guess that's where I saw the toggle thing. Is there a way to do
> a range of cells?
>
> --
> bre
> ------------------------------------------------------------------------
> bre's Profile: http://www.excelforum.com/member.php...o&userid=20765
> View this thread: http://www.excelforum.com/showthread...hreadid=470485

--

Dave Peterson