To paste a vertical list across a row in Excel, select and copy the list, click the first destination cell, then choose Home > Paste > Transpose. Excel turns the copied column into a row. This guide covers that method, as well as what to check when you want to paste data across existing columns or the result does not look right.
What You’ll Need
- An Excel workbook open in Microsoft Excel for Microsoft 365 on Windows. The steps are similar in other recent desktop versions.
- A source range containing the cells you want to turn sideways. The source can be one column or a rectangular block.
- A destination area with enough empty cells for the transposed range. You usually select only the destination’s top-left cell.
For example, if your source is a column with five entries, the transposed result will need five columns in one row. If you are working with important information, consider saving a copy of the workbook first. Pasting over cells replaces their existing contents.
Step-by-Step
- Check the source range. Identify the exact cells you want to paste. To turn a single column into a row, select the column’s populated cells, such as A1:A5, rather than the entire worksheet column. To transpose a larger block, select the full rectangle. Excel swaps the range’s rows and columns: a 3-row-by-2-column selection becomes a 2-row-by-3-column result. Include headers if you want them turned sideways too.
- Copy the selected cells. Press Ctrl+C on Windows, or right-click the selection and choose Copy. A moving dashed border usually appears around the copied range. Do not cut the cells if you want the original information to remain in its current location. Copying also lets you try again if the first paste is not what you expected.
- Choose the destination’s first cell. Click the cell where the top-left corner of the transposed result should begin. For a column of names that should become a row, click the cell where the first name should appear. You generally do not need to preselect a whole row or a set of destination cells. Excel calculates the output dimensions from the copied range.
- Use the Transpose paste command. On the ribbon, open Home > Paste and select Transpose from the paste options. Depending on the ribbon layout, you may see Transpose as a labeled option or an icon in the Paste menu. You can also right-click the destination cell, choose Paste Special, and select Transpose. If the Paste Special dialog opens, leave the Transpose checkbox selected and click OK.
- Check the result and the surrounding cells. Confirm that the first source cell is now in the destination’s first cell and that the remaining entries run horizontally. Check the last entry too: it should land in the expected final column. Make sure the result has not overwritten labels, formulas, or other data nearby. If it has, immediately press Ctrl+Z to undo the paste, then choose a clear destination.
- Choose how much of the source to preserve, if needed. The basic Transpose paste is useful when you want the copied range, including its usual cell content and formatting, to be turned sideways. If you only want the results and not the source formulas or formatting, open Paste Special, choose Values, and keep Transpose selected before confirming. Review the available choices in the dialog before clicking OK.
- Finish by removing the copy border. Press Esc after the paste if the moving dashed outline is still visible. This cancels the remaining copy operation; it does not undo the paste. Save the workbook when the result is correct.
Excel for Mac: The ribbon’s Paste menu also includes a Transpose option in current desktop versions. You can also use Paste Special from the menu or context menu and select Transpose. The common copy shortcut is Command+C rather than Ctrl+C; the Paste Special keyboard shortcut is usually Control+Command+V. Menu wording and shortcut behavior can vary by Excel version, so use the visible Paste Special command if a shortcut does not open the dialog.
Excel for the web: Copy the range, select the destination cell, and look for Transpose in the Home > Paste options or the right-click paste menu. If the option is unavailable in your browser or current interface, open the workbook in the Excel desktop app and use Paste Special > Transpose.
Common Mistakes
- Choosing ordinary Paste instead of Transpose. A standard paste keeps the original row-and-column arrangement. Open the Paste menu and select Transpose specifically; the usual Ctrl+V shortcut does not transpose data by itself.
- Selecting the wrong source range. Extra blank cells or a header you did not mean to include will also be pasted. Check the highlighted selection before copying, especially if the data sits beside other tables.
- Selecting too much destination space. For a standard copied-range paste, click just the top-left destination cell. If you select an area that is too small or the wrong shape, Excel may show an error or not paste as intended.
- Overwriting existing information. A transposed paste fills cells to the right and, for a multirow source, down from the destination. Check that the entire destination footprint is clear before you paste, not just the first cell.
- Expecting a live link to the source. A paste creates a separate result; it does not automatically make the transposed cells update whenever the source changes. If you need a result that updates with its source, use a TRANSPOSE formula or repeat the paste after editing the source.
- Assuming formatting will always be wanted. Transpose can carry formatting from the copied cells. If the destination uses a different style, use Paste Special options to paste values without the source formatting, or apply the destination formatting afterward.
Tips
- Use a small test when the data is important. Copy a few representative cells and transpose them into a blank area first. This helps reveal whether the result includes the formats, formulas, or values you expect before you work with a large range.
- Think about the output shape before choosing a destination. A 1-column range becomes 1 row; a 1-row range becomes 1 column. A block with several rows and columns swaps those dimensions. Leave room for the full result in every direction.
- Use Values when the source contains formulas you do not want to carry over. In Paste Special, choose Values and Transpose together. The resulting cells contain the values currently displayed by the formulas, rather than the formulas themselves.
- Preserve the original source until you have checked the output. Copy, rather than cut, when you are unsure. Once the transposed result is confirmed, you can decide whether the original cells should remain or be removed.
- Keep labels in mind. If the first source cell is a heading, it will also be transposed. Include it when the new row needs a label; leave it out when you only want the data entries.
- Use Undo promptly if the paste is wrong. Ctrl+Z on Windows or Command+Z on Mac reverses the latest paste in the current session. If you have performed other actions since pasting, check the Undo history before using it so you do not undo more than intended.
Troubleshooting
Transpose is missing from the Paste menu. Make sure you copied a cell range first; Transpose paste options may not appear when there is no copied selection. Try right-clicking the destination and opening Paste Special. In Excel for the web, switch to the desktop app if the browser version does not offer the option in its current interface.
Excel says the copy and paste areas are different sizes. This can happen when you select a destination range that does not suit the copied range, or when the copied cells are not a single rectangular block. Press Esc, copy one continuous rectangular range, and click only the destination’s top-left cell before transposing. If the message persists, check for merged cells in either area; merged cells can constrain how Excel pastes a range.
The paste fails or cells do not appear where expected. Check whether the worksheet is protected, whether the destination contains merged cells, and whether the destination area is available for editing. Confirm that you copied the intended cells rather than a different range. If the target area has existing content, undo the paste and choose an empty area large enough for the transposed result.
The output contains formulas or unexpected formatting. Undo the paste, reopen Paste Special, and choose the combination you need. Values plus Transpose is appropriate when you want the current results without formulas; a different paste option may be better if you need formulas or formatting. After pasting, inspect a few cells rather than assuming every item was handled the same way.
The result does not update when the source changes. That is normal for a regular paste. Paste Special creates a one-time copy. To keep a transposed view linked to its source, use Excel’s TRANSPOSE worksheet function in an empty area; in Microsoft 365, the returned values can spill into neighboring cells. If you prefer a static result, copy and transpose the range again after changing the source.
Frequently Asked Questions
How do I paste a row vertically in Excel?
Copy the row, click the top cell where the new column should begin, and choose Home > Paste > Transpose. The row’s first cell goes into the top destination cell, and the other entries continue downward.
Does Transpose delete or move the original cells?
No. When you copy and transpose, the source stays where it is and Excel creates a separate pasted result. To remove the original afterward, check the transposed data first, then delete the source cells only if you are sure they are no longer needed.
Can I transpose more than one row or column at once?
Yes. Copy a contiguous rectangular range and use Transpose. Excel swaps the number of rows and columns, so a range with four rows and three columns becomes a range with three rows and four columns. Make sure the destination has space for the complete result.
Can I transpose values without copying the source formatting?
Yes. Open Paste Special, select Values, and make sure Transpose is checked before confirming. This pastes the calculated or entered values in the new orientation without applying the source cells’ number formats, fonts, and fills in the usual way.
Can I make the transposed data update automatically?
Yes, use the TRANSPOSE function rather than a one-time paste. In Microsoft 365, enter the function in the destination’s first cell and Excel spills the transposed result into the adjacent cells. The destination spill area must be empty. Use Paste Special > Transpose when you want a fixed copy instead.
Why does my pasted result look different from the source?
Transposing changes the layout, and the paste option you select affects what carries over. Formulas, number formats, and other formatting may not behave like plain text. Use Paste Special to select the desired content, inspect the result, and adjust the destination formatting if needed.
Related
- How to Insert a Line in a Word Header Step by Step
- How to Insert a Line in a Word Table: Step by Step
- How to Insert a Line Between Columns in Microsoft Word
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Insert an Electronic Signature in WordTo insert an electronic signature in Word, add a picture of your handwritten signature, draw one with the…
- How to Create a Calendar Template in Word That You Can ReuseTo create a reusable calendar template in Word, make a seven-column table for the days of the week,…
- How to Delete a Blank First Page in Microsoft WordTo delete a blank first page in Microsoft Word, show formatting marks, remove any empty paragraphs or page…
- Excel File Compare: How to Find Differences Step by StepTo compare two Excel files, use Spreadsheet Compare or Excel’s Inquire add-in if your Windows edition includes it;…
- Google Sheets Distinct Values: Find, Filter, and Count ThemTo list distinct values in Google Sheets, enter =UNIQUE(A2:A100) in an empty cell, replacing the range with your…
- Out of Office in New Outlook: Set It Up and Schedule ItTo set up an out-of-office reply in New Outlook, open Settings, go to Accounts > Automatic replies, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.