You’ve set up a worksheet, when you realize it would look better if the rows and columns were reversed. There’s no need to?re-enter all that data. Just use Excel’s Transpose feature.
Select the cells containing the headings and data you want to transpose.
Click the “Copy” button or press Ctrl+C to copy the selected cells.
Click a blank cell where you want to copy the transposed data. The cell you select becomes the top, left corner of whatever you’re copying.
Click the down arrow under the “Paste” button, and then click the “Transpose” button on the dropdown menu.
Just like that, your rows become columns and your columns become rows—complete with any formatting you’d already applied to the original selection.
Note that your original, pre-transposed data still exists. You can select those cells again, and delete them if you want.
It’s a quick trick, but it sure is a lot quicker and easier than retyping all your data and formatting those rows again.
- › How to Set Row Height and Column Width in Excel
- › How to Add or Delete Columns and Rows in a Table in Microsoft Excel
- › How to Use the Paste Special Options in Google Sheets
- › How to Convert a Row to a Column in a Microsoft Word Table
- › How to Move Columns and Rows in Microsoft Excel
- › The Best How-To Geek Articles About Microsoft Office
- › Convert a Row to a Column (or Backwards) in Google Docs Spreadsheets
- › Using Wi-Fi for Everything? Here’s Why You Shouldn’t