Slider

How to Transpose Rows and Columns in Excel

Date:2019-7-16 Author:Cordelia

If you are not satisfied with the current state of your table in Excel, and consider the content in rows should be in columns or vice versa, you can transpose them using the feature of Paste Special.

Let's see an example. I have this table below and want to switch the rows and columns. So I select the whole table and press "Ctrl+C" to copy it.

How to Transpose Rows and Columns in Excel

Then right click anywhere you want to output the new table. Find Paste Special in Paste Options and select the icon of Transpose.

How to Transpose Rows and Columns in Excel

Now a new table is created and the rows and columns in it are contrary to the former one.

How to Transpose Rows and Columns in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *