Copying row formulas to a column?

[Skip]

Can I copy a row of 12 cells/formulas, to a column of 12 cells. I
need the formulas in
the same order. Or do I need to copy each cell separately? thanks
for any assistance
Skip

 

[Shane Devenshire]

Hi,

Select the row and choose copy
Select the destination cell (top left corner) and choose Edit, Paste
Special, Transpose.

 

[Gord Dibben]

I would say depends upon whether or not all the formulas have absolute
references.

If absolute, copy>paste special>transpose.

If relative references, transpose will return #REF! errors.


Gord Dibben MS Excel MVP

 

[David Biddulph]

If you are lucky, transpose will return #REF! errors.
If you are unlucky you'll just get the wrong answers. :-(

 

[Gord Dibben]

Good point..........all depends upon where you select the transpose range.


Gord

 

[Ashish Mathur]

Hi,

You can use the transpose function

Suppose you want to transpose A2:L2 to B3:B14, then highlight B3:B14 and
then type the following formula =transpose(A2:L2) and confirm with
Ctrl+Shift+Enter.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com