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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
copy data while skipping a predetermined number of cells 5
Hide columns based on row values 2
Excel VBA 1
Trying to add column headings to array formula 1
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Coping Cross Tab Formulas 3
using the =page! feature to transpose a row to column 0

Back
Top