Select the entire range to transpose.
Edit|replace
what: = (equal sign_
with: $$$$$
replace all

Now your formulas are plain old text.

Select that range
edit|Copy

Off to the other sheet
Select the top left cell of the range to paste into
edit|paste special|click Transpose

Now change the plain old text back into formulas.

Select the range
edit|Replace
what: $$$$$
with: =
replace all

And remember to do it in the original location, too.

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

--

Dave Peterson