How do I change the default cell reference from absolute to relati

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JZing - 17 Jul 2006 13:23 GMT

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?

Reply to this Message

Dave Peterson - 17 Jul 2006 17:15 GMT

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.

> 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?

Signature

Dave Peterson

Reply to this Message

JZing - 17 Jul 2006 17:42 GMT

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

> I don't think it was you.
>
[quoted text clipped - 11 lines]
> > absolute. What menu setting do I have to change to get the default back to
> > relative?

Reply to this Message

Dodgester - 19 Jul 2006 01:03 GMT

I never realized the F4 trick. However, I must also agree with Dave,
there is no way of being able to change this pattern without having to
deal with macros. Even when dealing with macros, there is no real way
of having those codes triggered without having to use the
WorksheetChange Event on either every single worksheet of every
workbook that you touch or on every ThisWorkbook module of every
workbook that you touch. If you were to use this method, it could
create problems for others that may be modifying thus you must also
provide for some sort of trapping mechanism in order to prevent hassles
for other users.

Sincerely,

Ronald R. Dodge, Jr.

--
Dodgester

Reply to this Message