Have you ever been creating a spreadsheet in Excel when you suddenly realize: "Oh no! These columns should actually be rows." (Or the other way around?) Then you proceed to delete all of your column headers and re-type them as rows? Wouldn't you rather just have them magically switch direction? They actually can!
In the illustration below, I have my days as columns, and I want to change them to be presented in rows...without retyping them all. I know it doesn't seem like much in this case, but what if my columns were months of the year...for the last eight fiscal quarters?!
To make this change, you highlight the cells labeled Sunday through Saturday, and then right-click and select 'Copy'...like so:
Then go to the cell you want to become the first row, right-click, and select 'Paste Special...':
That will open the Paste Special dialog box, where you activate the 'Transpose' checkbox and click the 'OK' button:
And suddenly you have your columns in rows WITHOUT RETYPING! How cool are you now?
By the way, did you notice all the other options available to you in the Paste Special dialog box? Some of those can make your work easier, too. Go on and try them out!
Leave us a comment and let readers know what Excel tips you use on a daily basis.