Copying row formulas to a column?

  • Thread starter Thread starter Skip
  • Start date Start date
S

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
 
Hi,

Select the row and choose copy
Select the destination cell (top left corner) and choose Edit, Paste
Special, Transpose.
 
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
 
If you are lucky, transpose will return #REF! errors.
If you are unlucky you'll just get the wrong answers. :-(
 
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
 
Back
Top