Switch Excel columns and rows

When using Excel to write down things, I often end thinking I’d rather have used another layout. Most of the time, I want to switch columns and rows to get a better “one-screen” view.

Excel, transpose columns and rows

Well in fact, it’s quite easy to do:

  • Select your Excel data ;
  • Use the Edit menu, select the Copy command ;
  • Insert a new sheet in your spreadsheet ;
  • Select the A1 cell and, in the Edit menu, select the Paste Special... command ;
  • Check the Transpose option and click OK.


Note that you may transpose the data in the same sheet in you wish to.
Here’s a shot of what

Author: Joel Carnat

@work Technical Architect and SysAdmin ; @home OpenBSD and FOSS, Karate, Kobudō, Jōdō, Bodyweight workout, Photography & Music

Leave a Reply

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


This site uses Akismet to reduce spam. Learn how your comment data is processed.