How to Paste Data Horizontally in Excel Using Transpose

How-to basics · Updated November 21, 2026

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

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.