Have you ever had a ‘Doh!’ moment in Excel and wished you had made the rows the columns, and the columns the rows? Never fear – Excel has a solution! There is an option in the Paste Special dialog to ‘Transpose’. When you transpose a block of data in Excel the labels on the left and the labels on the top will switch places, and the data in the table will rearrange accordingly.
Here’s an example of how to transpose rows and columns in Excel:
- Select the block of cells that you would like to transpose and press Ctrl + C to copy them. A blinking border should appear around the block.
- Click on the cell where you would like the upper left corner of the transposed data to start.
- Right click on that cell and choose Paste Special…
- In the Paste Special dialog, check the check box for ‘Transpose’ and click OK.
- The transposed data should now be pasted in the new location. And the blinking border around the original table should have disappeared.
Transpose is just one of the many knobs and dials in Excel. If you’ve used the Transpose feature before drop me a line or comment below and tell me about it. Cheers!
Wouldn’t real-time backups be nifty? No need to remember to backup. No waiting for folders and tons of files to copy over. And no loosing your work when your computer decides to kill over. All good things. Google Cloud Connect offers the ability back up your Word, Excel, and PowerPoint files to the cloud at no cost – overcoming all of these problems in one click. Ok, it’s not real-time, but almost!
