Copying from columns to Rows

**scottsman78** · 10-04-2005, 09:46 AM

Can anyone tell me if there is a way of copying a series of rows of cells in excel and pasting them as a whole to a series of columns?
I don't know if this can be done?

**swatsp0p** · 10-04-2005, 10:47 AM

Try Edit>Paste Special and check the "Transpose" box

Good Luck

**scottsman78** · 10-04-2005, 10:58 AM

Thanks Bruce,

That worked perfectly!

Scott,

Edinburgh, Scotland.

Dave O · 10-04-2005, 11:05 AM

Do you mean the Transpose function? Highlight your rows and copy them;
select the column you'd like, right click and Paste Special; then
select the Transpose box.

Jan Karel Pieterse · 10-04-2005, 11:05 AM

Hi Scottsman78,

> Can anyone tell me if there is a way of copying a series of rows of
> cells in excel and pasting them as a whole to a series of columns?
> I don't know if this can be done?

After the copy, select Edit, paste special and check the "transpose"
box.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com