In Excel can I rotate a column from vertical to horizontal.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Data is exported into Excel as a vertical column, is it possible to rotate
the column 90 deg to make it a horizontal row?
 
Hi

one option, select your data (as long as it's not more than 256 cells) and
copy it
click on a cell (e.g. A1) and choose edit / paste special - transpose
You can then delete the original list

Cheers
JulieD
 
Hi,

Yes, select the items and choose Edit/Copy then select a new cell and choose
Edit/Paste Special and check the transpose-box and hit ok.

Regards
Paul
 
Pls. copy it & then use paste special. there u wil see transpose. use
transpose.
 
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

Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
How to Convert same horizontal row to vertical row in Excel? 3
How to rotate graph 90 degrees 1
Flipping data - columns to rows and visa versa 2
Word How to rotate individual letters in word 2016 0
Rotate column headings - ??? 3
How to rotate a list of numbers? 4
horizontal lines to vertical 5

Back
Top