How to Paste and Transpose in Excel Without Re-typing

How-to basics · Updated November 21, 2026

To paste and transpose in Excel, copy the cells, select the top-left cell of a blank destination, then choose Home > Paste > Transpose. This switches rows to columns and columns to rows while keeping the copied data in place. Before you start, make sure the destination has enough room and will not overwrite information you need.

What You’ll Need

  • A workbook open in Excel for Microsoft 365 on Windows. The steps are similar in Excel for Mac and Excel for the web, although some menu labels and shortcuts differ.
  • The range you want to turn around: for example, a row of monthly headings or a table with several rows and columns.
  • A clear destination area large enough for the transposed range. A range that is 3 columns wide and 2 rows tall will become 2 columns wide and 3 rows tall.

Step-by-Step

  1. Select the cells to transpose. Click the first cell and drag to the last, or click the first cell, hold Shift, and click the last. Check the outline to confirm that you have selected the complete rectangular range. If the data includes headings, include them in the selection if you want them turned along with the rest of the data.
  2. Copy the selection. Press Ctrl+C on Windows. Copying is safer than cutting: Excel needs the copied range for the transpose paste, and the original remains available if you want to compare the result. A moving dashed border usually indicates that the range is on the clipboard.
  3. Choose the destination’s top-left cell. Click a blank cell where the new arrangement should begin. For example, if you copied a range that is 4 rows by 3 columns, the result will occupy 3 rows by 4 columns starting at this cell. Leave that full destination area clear; otherwise, the paste may replace existing contents.
  4. Open the transpose paste command. On the Windows ribbon, select Home > Paste > Transpose. Depending on the ribbon layout, Transpose may appear as an icon in the Paste menu, so look for its label or hover over the icon to confirm it. Excel pastes the copied cells in the opposite orientation.
  5. Check the result before moving on. Compare the first and last entries with the source, and confirm that headings now run in the direction you expected. Also look for missing values, unexpected formula results, or formatting that did not carry over as intended. The source range is not deleted by this process.
  6. Use Paste Special when you need more control. After copying, select the destination and choose Home > Paste > Paste Special. In the dialog, select the content type you want to paste, such as Values or Formulas, check Transpose, and click OK. This is useful when you want to turn the layout around but do not want to copy every aspect of the source, such as its formulas or formatting.
  7. Use a keyboard route if you prefer. On Windows, copy the range, select the destination, press Ctrl+Alt+V to open Paste Special, select Transpose in the dialog, then choose OK. Dialog keyboard focus can vary, so check that Transpose is checked before confirming. On Mac, use Command+C to copy and look for Edit > Paste Special or the Paste Special options on the Home ribbon; the available shortcut can depend on the Excel version and keyboard settings. In Excel for the web, use the ribbon’s Paste menu and choose Transpose if the option is available in your current interface.

For example, suppose A1:C2 contains two rows and three columns: the first row has Q1, Q2, and Q3, and the second row has 10, 12, and 15. Pasting with Transpose into E1 produces three rows and two columns: Q1 beside 10, Q2 beside 12, and Q3 beside 15. This is handy for turning a row of labels into a vertical list, or changing a horizontal summary into a format that is easier to chart.

Paste Special is a one-time copy operation, not a live link. If the original cells change later, the transposed pasted result will not automatically refresh. If you need a result that updates with its source, use the TRANSPOSE function instead. With the source data in A1:C2, enter =TRANSPOSE(A1:C2) in the top-left cell of a blank destination. In Microsoft 365, the result spills into a 3-row-by-2-column area automatically. Keep that spill area clear; Excel cannot display the full result if a cell in the required area is occupied. In older Excel versions, select the 3-row-by-2-column output range first, enter the formula, then press Ctrl+Shift+Enter rather than Enter alone.

Common Mistakes

  • Choosing a destination that is too small or occupied. The transposed range changes dimensions. Check its new width and height before pasting, and make sure no important entries are in its way. Pasting over cells replaces their contents; Undo with Ctrl+Z immediately if you notice an overwrite.
  • Expecting the original to move or disappear. Transpose paste copies the range into a new orientation. It does not remove the source. If you want only one copy, verify the pasted result first, then delete the original separately.
  • Using the wrong paste option. The standard Transpose command may carry formulas and formatting as well as displayed values. If you only need the visible results, use Paste Special, choose Values, and check Transpose. If you need formulas to remain formulas, choose the appropriate formula option instead.
  • Assuming formulas will behave exactly as before. Relative references can adjust when formulas are copied to another location. After transposing a formula-containing range, inspect representative formulas and their results. If a reference must stay fixed when copied, it may need an absolute reference, such as $A$1, in the original formula.
  • Selecting only part of a range or including extra cells. A missed heading or an accidental blank row can make the result look misaligned. Check the selection outline before copying, especially when choosing a range with the mouse.
  • Trying to transpose merged cells or paste into a structured table. Merged cells can prevent the paste from working as expected, and a destination inside an Excel table may restrict the operation. If you encounter an error, unmerge the source or choose a normal worksheet area outside the table, then transpose and reorganize the result as needed.

Tips

  • Work beside the source first. A nearby blank area makes it easy to compare the original and transposed versions. Once you are satisfied, you can move or copy the finished result to its final location.
  • Use Paste Special to keep the result tidy. If the source has colors, borders, or number formats that do not suit the new layout, paste Values with Transpose, then apply the formatting you want to the destination. You can also choose another paste type in the dialog if the version of Excel offers the exact combination you need.
  • Think about formulas before choosing. A formula-based transpose is useful when the source changes regularly, while a paste is convenient for a fixed snapshot. If you only want a fixed snapshot of a formula’s current result, use Values with Transpose rather than keeping a live formula link.
  • Preserve a clean copy for important work. When reorganizing a large or critical worksheet, save the workbook or duplicate the sheet first. That gives you a simple way back if a paste replaces data or produces a layout you did not intend.
  • Remember the platform shortcuts. Windows uses Ctrl+C to copy and Ctrl+Z to undo. On Mac, use Command+C and Command+Z. The ribbon command is often the clearest option if your keyboard shortcut opens a different dialog or is affected by system settings.

Troubleshooting

Transpose is unavailable or the paste does nothing: Copy the cells again, then click a single destination cell rather than selecting an incorrectly sized output range. Confirm that the copied range has a moving outline and that the destination is not part of a merged area or a restrictive table. If using Excel for the web, try the Paste menu on the Home ribbon; if the option is not shown, open the workbook in the desktop app.

Excel says the destination is not the same size: With the standard transpose paste, select only the destination’s top-left cell. Excel calculates the new dimensions from the copied range. If you are entering a TRANSPOSE formula in an older version, select an output range with the reversed dimensions before entering it.

The result has unexpected values or formatting: Undo immediately if needed, copy the source again, and reopen Paste Special. Select Values if you want displayed results, or choose a formula option if you need formulas. Check whether number formats, borders, and fills are appropriate for the new layout; you may need to format the destination separately.

The TRANSPOSE formula shows an error or will not spill: Clear cells in the area where the result needs to appear, including cells that look blank but contain spaces or formulas. Check that the formula refers to the intended source range. If you are using an older Excel version, enter it as an array formula by selecting the full output range and pressing Ctrl+Shift+Enter. If the source is an Excel table, a formula referring to a normal worksheet range may be simpler for a one-off transpose.

You pasted over something important: Press Ctrl+Z on Windows or Command+Z on Mac immediately. If you have made more changes since then, stop and check the workbook’s version history or saved copy before attempting further edits. Undo is most reliable before closing the workbook or performing additional operations.

Frequently Asked Questions

Does transpose delete the original data?
No. Copy and Transpose creates a rearranged copy at the destination and leaves the source cells in place. Delete the original only after checking that the new version is correct.

Can I transpose without changing the formatting?
Usually. The regular Transpose paste generally carries the copied formatting. For more control, open Paste Special, choose the content to paste, and check Transpose. The exact options can vary slightly by Excel version.

Can I transpose a row and a column?
Yes. A one-row range becomes a one-column range, and a one-column range becomes a one-row range. Copy the cells, choose a blank destination, and use Home > Paste > Transpose.

Will a transposed paste update when I edit the source?
No. Paste Special creates a static copy. Use the TRANSPOSE function if you want the displayed transposed result to update when its referenced source cells change.

Can I transpose data in Excel for Mac or the web?
Excel for Mac has transpose paste options, though the menu location and keyboard shortcuts can differ from Windows. Excel for the web also provides paste options in its ribbon, but available commands can depend on the interface and workbook. If the command is missing, open the workbook in desktop Excel.

Can I transpose a range that contains blank cells?
Yes. Blank positions in the selected rectangle remain blank in the corresponding transposed positions. If blanks seem to disappear, check whether the copied area included the entire rectangular range and whether the chosen paste option changed how values or formatting were copied.

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.