rows into columns

  • Thread starter Thread starter barb
  • Start date Start date
B

barb

i need to swith my columns into rows and vice versa can i
do this?

thanks
 
Select the data that you want to "switch", go to an empty area (or a new
worksheet), select Edit | Paste Special, and check the "Transpose" box.
Click Ok.
 
edit copy cells
select a cell outside the range
edit paste special .........tick the transpose option at the bottom

Regards
Bill K
 
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

Reformat Row to Column 2
How do I restrict data entry to one of two columns but not both? 4
columns to rows flip 3
Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row 2
Cannot sort data 1
merge problem 1
How can I move data from a row range to a column range 4
How do I restrict data entry to one of two columns 2

Back
Top