moving formuals

[awpd]

I need to move formulas from one spread sheet to another, The formulas I need to move are set in column A,(A1, A2, A3, A4 and so on). I want to set them in Rows on the other sheet (A1, B1, C1 ect...).
How can I transfer all formulas at once from columns to rows? I can only manage to move them one at a time and this will take for ever.
pls help.

[royUK]

Have you tried using PasteSpecial >-Transpose?

[martindwilson]

copy all
then on other sheet click a1 paste special select formulas and transpose