You just spent time setting up a new worksheet and realized that you want the columns to be rows and the rows to be columns. Well don’t fret, you do not need to start from scratch.

Just highlight the table, click Copy, then go to another area of the worksheet and select Paste Special. On the Paste Special screen, check the “Transpose” box, and hit OK.

The rows are now columns and the columns are now rows.

Related posts:

1. MS Excel Tip: Delete Duplicate Rows from a List in Excel A duplicate row (also called a record) in a...
2. Website of the Month: Formatit.com Formatit.com is an email formatting and text formatting tool....
3. Twitter Resource: HootSuite Deborah Smith, a social media expert, got me hooked...
4. MS Word Tip: Putting Document Names in Headers or Footers You found a document that you printed some time...

Subscribe/Follow Me