Autofill nightmare

[Guest]

Ive used excel off and on for a while, i just installed the new 2003 office. Working on a spreadsheet..where i needed to copy a row and column of formulas from one sheet to another, and transpose them. I did a select of a row of formulas..and went to the page. clicked on a cell and selected paste special, selected the formula only and the transpose. It pasted into the right number of cells, however..it didnt retain the formulas exactly as copied. I tried copying just one cell..and pasted the formula onto a new sheet..but when i grabbed the corner and dragged..it incrimented the values incorrectly.. so then i put a $ in front of the alpha value leaveing the number alone..then did a drag..and it copied the formula exact as the original without incrementing the number value. the formula might look like =report!A
i changed it to =report!$A3 but this did no good when autofill across a row. Any ideas? im not understanding why the formula locks arent working.

 

[Dave Peterson]

You want the formulas kept exactly the same--except transposed when you paste
them?

If yes, you can:
Select the original range
Edit|replace
=
with
$$$$$=
(now all those formulas are text

copy and paste special|Transpose

Then edit|replace
$$$$$=
with
=
(both ranges)
To convert the text back to formulas.

 

[Guest]

Thanks for the work around. Is this inability to paste accurately a new excel feature? hahaha

 

[Dave Peterson]

One of many <bg>.

Thanks for the work around. Is this inability to paste accurately a new excel feature? hahaha