Tuesday, September 27, 2011

How to Quickly Change Orientation of an Excel Table

You may have a list of items going down a column.


For some reason you want to change the orientation to make it go across a row instead.

How can you do that?

It is quite easy actually.
Highlight all the items in the List and Right-Click Copy them.


Then go to any empty cell and Right-Click 'Paste Special...'
Note: Make sure that you allow for enough space for the row to go across. Otherwise your data may be overwritten.

Tick the Transpose Option.

VOILA! Your new list is ready.

2 comments:

Related Posts Plugin for WordPress, Blogger...