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

G

Guest

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

Guest

yes

Copy-->Edit-->paste special-->Transpose

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

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

Transpose, Paste Special 2
Excel Help to copy information from one row at a time to another sheet 1
Transpose function 4
copy/paste row with one formula 6
Forms 1
Macro - select and paste 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Copy & Paste 2

Top