Thanks. I didn't realize the default would change based upon cell location.

"Dave Peterson" wrote:

I don't think it was you.

If you are creating a formula and you point at a cell within the same workbook,
you'll see the relative address. If you use a cell in a different workbook,
you'll see the absolute address.

I've never seen anything that would change this behavior.

But you can select that reference and hit F4 a few times to cycle through all of
the relative/absolute addresses.

JZing wrote:

It is my understanding that cell references, by default, are set up to be all
relative. Somehow I've changed my defaults to have my cell references all be
absolute. What menu setting do I have to change to get the default back to
relative?

--

Dave Peterson