Transposing in Excel

Have you ever needed to reformat data so that the columns were the rows and the rows were the columns?
Transposing in Excel is straightforward and easy.

  • Select your data
  • Copy your data with Control + C
  • Click on the cell in which you want to transpose the data
  • Right Click and choose Paste Special
  • Check the Transpose box and click OK

Find more ways Excel can make your life easier with a training course from AdvantEdge Training and Consulting.

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top