Excel Tip Tuesday: Should your columns be rows?

Posted by Lisa on June 19, 2018 at 10:00 AM

Excel IconHave 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?!

Excel Tips - Format Transpose1

To make this change, you highlight the cells labeled Sunday through Saturday, and then right-click and select 'Copy'...like so:

Excel Tips - Format Transpose2

Then go to the cell you want to become the first row, right-click, and select 'Paste Special...':

Excel Tips - Format Transpose3

That will open the Paste Special dialog box, where you activate the 'Transpose' checkbox and click the 'OK' button:

Excel Tips - Format Transpose4

And suddenly you have your columns in rows WITHOUT RETYPING! How cool are you now?

Excel Tips - Format Transpose5

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.

Topics: Excel

Don't Miss a Thing!

Subscribe to our blog

Subscribe to our blog

    Recent Posts

    Posts by Topic

    see all