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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
yes

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

Note: Their are only 256 columns possible in excel, so you can only do this
for 256 rows.
 
You must log in or register to reply here.

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
Transpose, Paste Special 2
Transpose function 4
Macro - select and paste 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3
copy/paste row with one formula 6
Copy paste data from a column to a row 0
Forms 1

Back
Top