Auto-adjust references when adding rows/columns

Question

Level 1

0 points

Auto-adjust references when adding rows/columns

If I recall correctly, it was the behavior of Appleworks that if you added, say, column B, making the old column B into column C, all references to B throughout were automatically changed to C. This does not happen in Numbers. Is there any way to make this the default behavior or a different command to add rows/columns that causes references to automatically be adjusted accordingly?

iMac, Mac OS X (10.5.2)

Posted on Mar 7, 2008 6:13 PM

Reply

Answer 1

Mar 7, 2008 6:58 PM in response to neotwinkie

Neo,

I think that Numbers works pretty much the way you want it to. There may be others who have more experience and can tell you when it may not work, but for me, Adding and Deleting rows and columns results in cell references being adjusted.

Jerry

Message was edited by: Jerrold Green1

Reply

Answer 2

neotwinkie Author

Level 1

0 points

Mar 7, 2008 9:08 PM in response to Jerrold Green1

OK, this is going to make me sound really stupid, but I actually was so confused and tired that I meant the exact opposite of what I said. I was making a ledger-type spreadsheet keeping a running balance, and I wanted cells in the balance column to continue referring to the cell directly above them rather than to one absolute cell that used to be directly above them. That's how it works in Appleworks. I think.

Reply

Answer 3

KOENIG Yvan

Level 8

41,807 points

Mar 8, 2008 1:33 AM in response to neotwinkie

Hello

The syntax available in AppleWorks is available in Numbers.
Alas, the PDF User's guide describe only one kind.

Absolute references:

G$5
$G5
$G$5 the one described in the guide.

Yvan KOENIG (from FRANCE samedi 8 mars 2008 10:33:17)

Reply