I don't know about you, but I often lay out data on a spreadsheet and then change my mind about the orientation of it. Thankfully there is a quick and easy way to get MS Excel data to swap places - basically putting all your row data into columns and your column data into the rows.
This is what your data may look like to begin with.
Highlight all the information and
Copy. You'll see the ubiquitous "sparkling lines" appear around the data to confirm you've copied successfully. Now place your cursor into any other empty cell and choose
Paste. I do this by right clicking over the cell, but you can also click the
Paste button on the
Home tab of the ribbon.
From the
Paste Options list, select the
Transpose icon. That's it! Your data will now appear transposed perfectly.
A quick note...you can't use the CTRL V shortcut key to paste as this will not show you the Paste Options buttons nor can you cut the original data and perform a Paste Transpose.
More Excel tips and tricks coming your way soon. Let me know if there is anything in particular you're hoping to see.
No comments:
Post a Comment