Excel is loaded up with functions, but even changes like the Ribbon interface in recent releases don’t mean people find it easy to perform common tasks. Microsoft’s Inside Office Online blog has started a rundown of the most popular time-savers for Office (based on comments on existing posts). In the first batch, one for Excel stands out: how to convert rows to columns or vice versa using the Paste Special Transpose command. Hit the post for full details. Excel 2007 users will find Transpose under Paste in the Home tab.
Convert Columns To Rows In Excel
About the Author
Angus Kidman | Lifehacker Editor
Angus has been writing professionally about technology since 1994 and breaking it for even longer. He is based in Sydney but spends a frankly unhealthy portion of his life on the road, tracking down the latest stories. In 2011, he won the IT Journo Award For Best Consumer Technology Journalist and Consensus IT Writers Award for Best Technical Writer for his work on Lifehacker; about time too.