To paste a vertical list across a row in Excel, copy the cells, select the top-left destination cell, then choose Home > Paste > Transpose. To paste a row horizontally without changing its orientation, copy it and use Ctrl+V. These steps are for Excel for Microsoft 365 on Windows; have the source range ready and make sure the destination area is clear before you paste.
What You’ll Need
- An Excel workbook containing the cells you want to copy. To change a column into a row, select a vertical range; to keep data horizontal, select a row.
- An empty destination area large enough for the pasted result. A range with four rows and one column, for example, needs one row and four columns after you transpose it.
- Permission to edit the destination sheet. If it is protected or the cells are locked, you may need the sheet owner to allow edits or unprotect it first.
Step-by-Step
- Decide whether you need a normal paste or a transpose. Pasting horizontally can mean either placing a horizontal row in another location or turning a vertical list into a row. A normal copy-and-paste keeps the copied cells’ shape. Transpose swaps rows and columns: a column becomes a row, and a row becomes a column. Choose the method that matches the direction you want.
- Select the source cells. Click the first cell, then drag across the full row or down the full column. For a larger rectangular range, select all the rows and columns you want included. Check the highlighted selection before copying; Excel will transpose the entire selected rectangle, not just the active cell. You can also click the first cell, hold Shift, and click the last cell in the range.
- Copy the range. Press Ctrl+C on Windows. A moving dashed outline around the selection indicates that Excel has copied it. Use copy rather than cut for a transpose: Excel’s Transpose paste option is intended for copied data, and copying also leaves the original range in place as a backup. On Mac, press Command+C.
- Choose the destination’s top-left cell. Click the first cell where the result should appear; you do not need to preselect every destination cell. For a column of five cells, Excel will need five columns across the destination row. Ensure all those cells are empty, or be prepared for the paste to replace their contents. If you are keeping a copied row horizontal, click the first destination cell in that row.
- Transpose a vertical list into a horizontal row. With the copied cells still outlined, open the Home tab, click the arrow under Paste in the Clipboard group, and choose Transpose. The vertical list is placed across columns, starting at the destination cell. Depending on the ribbon layout, Transpose may appear as an icon in the Paste Options area; pause over an icon to see its label before clicking. In the Paste Special dialog, you can also select the Transpose checkbox and click OK.
- Paste a row horizontally without changing its orientation. After copying the source row, select the destination’s first cell and press Ctrl+V. Excel fills cells to the right, retaining the row layout. You can also use Home > Paste. This is the simplest option when your source is already horizontal and you only want a copy elsewhere.
- Check the pasted result. Confirm that the first and last values landed in the intended cells and that no existing data was overwritten. Transpose can carry formatting and formulas as well as values, so review number formats, borders, and any formulas. If the result is wrong, press Ctrl+Z immediately to undo, then repeat with the correct range or paste option. On Mac, use Command+Z to undo.
Mac and web note: In Excel for Mac, use Command+C and Command+V for copying and normal pasting; the Paste and Transpose options are available from the Home tab or paste menu, although their placement can differ slightly by version. In Excel for the web, copy the range, select the destination, and look for Transpose in the Paste menu. If that option is not shown in your browser, open the workbook in the desktop app and use the steps above.
Common Mistakes
- Using normal Paste when you meant to transpose. Ctrl+V preserves the original shape. A copied column will still go down the sheet. Use the Transpose paste option to turn it into a row.
- Selecting too much or too little. Excel copies every selected cell, including blank cells in the middle or at the ends. Extra blank cells can extend the pasted result and replace data in the destination. Recheck the highlighted source range before copying.
- Pasting over existing information. Clicking the first destination cell is enough; Excel fills the required area automatically. If any target cells already contain data, a paste can overwrite it. Choose a clear area or make a backup copy first.
- Expecting transpose to move the original data. Transpose creates a pasted copy; it does not remove the source. Once you have checked the new row, you can decide whether to keep or delete the original.
- Assuming formulas will behave like fixed text. A pasted formula may adjust its cell references, just as it can during a regular paste. Inspect formulas after transposing, especially if they refer to nearby cells or are part of a calculation.
Tips
- Use a spare area for a safer first attempt. If you are unsure how the result will look, transpose into an empty part of the sheet. Check it there before replacing or deleting the source data.
- Plan the destination dimensions. A source range that is three rows by two columns becomes two rows by three columns. Leave enough empty space in both directions so the pasted range does not collide with other information.
- Choose Paste Special when you need control. The Paste Special dialog can expose options such as Values and Transpose. Transpose changes the orientation; a values-only paste can avoid carrying formulas when you want their current results instead. Review the options shown in your Excel version before confirming.
- Keep labels aligned. When turning a list into a row, include its heading only if you want that heading to appear as the first item across. For example, selecting a department name along with four monthly totals creates five cells across, not just four totals.
- Use undo promptly if the result is unexpected. Ctrl+Z (Command+Z on Mac) is the quickest way to reverse an accidental paste. Do this before making more edits, because later actions can make it harder to return to the exact previous state.
Troubleshooting
- Transpose is missing or unavailable. Make sure you copied a cell range rather than cutting it, and that the copied range is still active. Press Esc only if you intend to cancel the copy, then copy the cells again with Ctrl+C. If the menu remains unavailable, try opening Paste Special from the Home tab or right-clicking the destination and checking its paste options.
- The data pasted down instead of across. That usually means Excel used a normal paste. Undo it, copy the source range again, select the destination’s top-left cell, and choose Transpose from the Paste menu. Do not select a horizontal destination range in advance; selecting its first cell is sufficient.
- Excel says the copy and paste areas are different sizes. This can happen when you manually select a destination range that does not fit the transposed dimensions. Press Esc or undo the failed action, select only the destination’s top-left cell, then paste again. Excel will calculate the required width and height from the source.
- Some cells did not paste or the result is blocked. Check whether the sheet is protected, the destination contains merged cells, or the target area is not empty. Try a clear, unmerged range on an editable worksheet. If the workbook is in a shared or restricted state, confirm that you have permission to edit it.
- Formatting or formulas look different afterward. Transpose may carry source formatting, and formulas may recalculate or adjust references. Undo if needed, then use Paste Special and choose Values if you only need the displayed results. If formatting is the problem, try a separate paste option suited to values or formats, or paste into a blank area and compare before changing the original.
Frequently Asked Questions
How do I paste a column into a row in Excel?
Copy the column, click the first cell where the row should start, then choose Home > Paste > Transpose. A column with six cells will fill six columns across.
How do I paste a row horizontally without transposing it?
Copy the row, select the destination’s first cell, and press Ctrl+V on Windows or Command+V on Mac. Normal paste keeps the row horizontal.
Can I transpose data without copying the original?
Paste Transpose creates a copy and leaves the source intact. After checking the pasted result, you can remove the original if you no longer need it. Keep a backup if the data is important.
Will Transpose keep cell formatting?
It commonly carries formatting along with the cell contents. If you want only the results and not the original formatting or formulas, use Paste Special and select the appropriate paste option, such as Values.
Can I transpose formulas as well as values?
Yes, but inspect the pasted formulas afterward. Their references may adjust during the paste, so check that each formula still points to the cells you intended.
Why did Excel overwrite cells beside my destination?
Excel fills enough cells to fit the whole copied range. Undo the paste, choose an empty area with enough columns or rows, and paste again from its top-left cell.
Related
- How to Insert a Page Break in Word for Windows and Mac
- How to Insert a Page-Wide Line Across a Word Document
- How to Insert a Neat Line in Word: Clean, Straight Results
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Embed Video in PowerPoint: Methods, Playback and FixesYes. In PowerPoint for Microsoft 365 on Windows, choose Insert > Video > This Device, select a video,…
- How to Copy and Paste Only Filtered Data in Excel SafelyTo copy only filtered records in Excel for Microsoft 365 on Windows, select the filtered range, press Alt+;…
- Excel Box and Whisker Plot: What Column Names MeanExcel box and whisker plots do not require special or reserved column names. Put each group of raw…
- How to Archive Outlook Emails to Your C Drive as a PSTTo archive Outlook emails on your C drive, use classic Outlook for Windows to export the mailbox or…
- Excel: How Many Complete Months Are Between Two Dates?To find the number of complete months between two dates in Excel, use =DATEDIF(A2,B2,"m"), with the earlier date…
- PowerPoint Timeline: The Easiest Way to Make One QuicklyThe easiest way to make a timeline in PowerPoint is to use SmartArt: go to Insert > SmartArt…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.