How are you removing the $ signs?

Are you in Edit mode while removing?

Did you use the F4 to cycle through the options per my second post?


Gord

On Tue, 12 Dec 2006 14:26:01 -0800, J M Bishop <J M
wrote:


To remove the dollar signs would seem to be the logical thing to do, however
I've tried this on two computers and in both cases the new "refers to"
formula references a random range of cells - different each time I try.

As an example, if I remove the "$"'s (all four) from:
=Sheet1!$C$11:$C$16
I get:
=Sheet1!IT16:IT21

John



"Gord Dibben" wrote:

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

On Mon, 14 Aug 2006 12:42:01 -0700, David Billigmeier
wrote:

Yes, follow these steps:

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