If you’re like most people, you probably use Excel to create tables and graphs. But what if you want to convert a row to a column in Excel? The easy way is to use the following steps:
- Open Excel and click on the Row button on the left side of the screen.
- Type in a value for the first column (e.g., 1), and then click on the Column button on the right side of the screen.
- Click on OK to finish converting your row to a column in Excel.
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.
