In this short video we explain and demonstrate how to easily swap / switch / rotate / transpose rows and columns in Excel.  The process is to:

  1. Select the rows and columns you want
  2. Right click and select COPY
  3. Right click on a cell in an open area of the worksheet (or a different worksheet) and select PASTE SPECIAL
  4. Select the TRANSPOSE option

We also demonstrate that some of the instructions given, even by Microsoft, are incorrect.


0 Comments

Leave a Reply

Avatar placeholder

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