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.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Skip" wrote:

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

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

If absolute, copypaste specialtranspose.

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


Gord Dibben MS Excel MVP

On Wed, 28 Jan 2009 14:53:47 -0800 (PST), Skip
wrote:

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

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

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I would say depends upon whether or not all the formulas have absolute
references.

If absolute, copypaste specialtranspose.

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


Gord Dibben MS Excel MVP

On Wed, 28 Jan 2009 14:53:47 -0800 (PST), Skip
wrote:

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

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


Gord

On Thu, 29 Jan 2009 11:39:57 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

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

"Skip" wrote in message
...
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