ExcelBanter - For Excel 2003: Is there a way to copy and paste a row of data to.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - For Excel 2003: Is there a way to copy and paste a row of data to. (https://www.excelbanter.com/excel-discussion-misc-queries/22516-excel-2003-there-way-copy-paste-row-data.html)

Marketing Grrrl

For Excel 2003: Is there a way to copy and paste a row of data to.

I'd like to copy a column of data and paste it into rows, and vise versa - is
there a way to do this?

Jonathan Cooper

yes

Copy--Edit--paste special--Transpose

Note: Their are only 256 columns possible in excel, so you can only do this
for 256 rows.

"Marketing Grrrl" wrote:

I'd like to copy a column of data and paste it into rows, and vise versa - is
there a way to do this?

All times are GMT +1. The time now is 05:56 PM.