Bug when copying formulas then using Edit...Paste Special...Transp

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy columns and paste with blank column between 5
Copy formula, paste special value add transpose into another formu 0
loop to copy paste 5
Copy and paste special 2
Copy and Pasting with Macros 0
Copy non merged to merged cells again 2
copy/paste in the next column 4
copy data from sheet2 to sheet1 when sheet2 has variable # of rows 6

Top