How to Transpose Rows and Columns in Excel 2016

Published: 26 February 2017
on channel: Excel, Word and PowerPoint Tutorials from Howtech

6,059

Don't forget to check out our main channel / howtech for more free how-to videos!
Join us on Facebook
/ howtechtv
Our App
http://bit.ly/how-tech

In this tutorial, we’re going to show you how to transpose rows and columns in Excel 2016.
The first method is to select your data, Copy it, and Paste it. After copying, right-click and go select Paste Special. Then find Transpose.

The other method is using the TRANSPOSE() formula. Select the area where you want the data to be transposed, and use TRANSPOSE() with your data as a parameter.

Watch video How to Transpose Rows and Columns in Excel 2016 online, duration hours minute second in high quality that is uploaded to the channel Excel, Word and PowerPoint Tutorials from Howtech 26 February 2017. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 6,059 times and liked it 10 visitors.