name range from absolute to relative

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WCO - 14 Aug 2006 20:23 GMT

When you give a cell a name it defaults to absoute reference. Can you change
the reference from absolute to relative.

Signature

Your time and consideration would be greatly appreciated.

WCO

Reply to this Message

David Billigmeier - 14 Aug 2006 20:42 GMT

Yes, follow these steps:

<Insert><Name><Define...>
Find your named range in the list and take out the dollar signs.

Signature

Regards,
Dave

> When you give a cell a name it defaults to absoute reference. Can you change
> the reference from absolute to relative.

Reply to this Message

Gord Dibben - 14 Aug 2006 21:45 GMT

And to remove dollar signs you would select the Refers to: box and hit F2 to get
into edit mode.

Select the referenced cells and F4 to cycle through the options untill you get
to relative reference.

Gord Dibben MS Excel MVP

>Yes, follow these steps:
>
><Insert><Name><Define...>
>Find your named range in the list and take out the dollar signs.

Reply to this Message