Excel Transpose data

One final example of a copy and paste is the amazing time-saver 'Transpose'

Let's say you have some data in your spreadsheet listed in rows, but you actually want them to be column headers.

You could retype the headers or do a 'copy and transpose paste'



1 - Select the cells.
2 - Select the cell to paste to and right-click.
3 - Select 'Paste special'

4 - Tick 'Transpose'

5 - Click 'OK'.

The headers are now horizontal rather than vertical.

While I don't use this a lot - for the times when I have needed this, it's saved a lot of time!