How do I change the default cell reference from absolute to relati
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
|