B
byundt
In Sheet1!A1 I entered the following formula:
=Sheet2!A$1 + Sheet2!A$2
I copied it across to column G and got the expected incrementing in column
letter.
I then copied cells B1:G1, and did an Edit...Paste Special...Transpose in
cell A2. The result was not what I expected, however:
=Sheet2!$A2 + Sheet2!B$2
Note how the first item being summed switched the absolute reference from
row to column, while the second item got it right. This behavior occurs in
Excel 97, 2000, 2002 & 2003
=Sheet2!A$1 + Sheet2!A$2
I copied it across to column G and got the expected incrementing in column
letter.
I then copied cells B1:G1, and did an Edit...Paste Special...Transpose in
cell A2. The result was not what I expected, however:
=Sheet2!$A2 + Sheet2!B$2
Note how the first item being summed switched the absolute reference from
row to column, while the second item got it right. This behavior occurs in
Excel 97, 2000, 2002 & 2003