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

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?
 
J

JulieD

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
 
P

Paulw2k

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
 

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

How to rotate graph 90 degrees 1
How to Convert same horizontal row to vertical row in Excel? 3
Word How to rotate individual letters in word 2016 0
How to rotate a list of numbers? 4
format Column with horizontal alphabet label 3
Borders Rotating 90 Degrees 1
Change from columns to rows and back 3
horizontal lines to vertical 5

Top