Excel Transpose: To swap rows and columns

ULTIMATE-TECH-NEWS shows you in this short tips on how to swap the rows and columns of your table with just a few clicks from Excel of 2010.

The rows and columns of your Excel spreadsheet, you can share with a few clicks (transpose).

The rows and columns of your Excel spreadsheet, you can share with a few clicks (transpose).

When you (from Excel 2010) edited in Excel a table and in the process want to swap the rows and columns, that is a matter of only a few seconds – if you know the right way.ULTIMATE-TECH-NEWS shows you how to proceed.

Find it: rows and columns Swap

Highlight the desired table using the mouse and copy it using the key combination Ctrl? +? C . Then click with the right mouse button on a free cell and insert content . After clicks Transpose and OK the table is reordered.

 

Post A Comment

Social media & sharing icons powered by UltimatelySocial