You can do it with a macro, OR:in a few extra steps
Select the entire row you want to transpose ( row3 of sheet1). Go to
EDITREPLACE
type in the exclamation mark !
Replace with type in : !$
then replace all.
Then do the same with the number 3 Replace what : 3 with $3 - replace all.
Now you have absolute reference of the formulae. Now copy the row ( row 3 )
with the formulas you need, go to the sheet you want to transpose them to and
then: EditPaste SpecialAllTransposeok.

"kassie" wrote:

I have the following formulas in row 3 of a sheet:
A3: =Sheet1!A3
B3: =Sheet1!B3,
C3: =Sheet1!C3
and so on across to column O

On a seperate sheet, i want to transpose these formulas, so that I will
enter in A4: =Sheet1!A3
A5: =Sheet1!B3
A6: = Sheet1!C3,
and so on down. Any idea how I can achieve this other than having to retype
the formula in every row?
--
Hth

Kassie Kasselman
Change xxx to hotmail