In Excel for Microsoft 365 on Windows, copy the cells, select an empty destination, and press Ctrl+Alt+V, then E, then Enter to open Paste Special and transpose the copied range. This turns rows into columns and columns into rows; the result is a static copy, not a live link to the source.
Use the Excel transpose shortcut step by step
The shortcut works through Excel’s Paste Special dialog. First select and copy the entire rectangular range you want to turn. Then click the top-left cell where the result should begin. The destination needs enough empty cells to fit the rotated shape: a range that is two rows by three columns becomes three rows by two columns.
- Select the source range and press Ctrl+C. A moving dashed border usually marks the copied cells.
- Select a blank destination cell outside the source range. Choose the cell that should become the top-left corner of the result.
- Press Ctrl+Alt+V to open Paste Special, press E to select Transpose, and press Enter to paste.
For example, copying A1:C2 and choosing E1 as the destination places the original first column down E1:E2, the second column down F1:F2, and the third down G1:G2. The resulting block is E1:G2 only if the source had three rows; for the two-row, three-column example, the output occupies E1:F3. Checking the output dimensions before pasting helps avoid overwriting nearby data.
This sequence assumes Excel recognizes the keyboard accelerator in the Paste Special dialog. If pressing E does not check Transpose in a particular installation or localized interface, open the dialog and click its Transpose checkbox instead. The essential action is the same; the dialog is simply a reliable visual way to confirm the selected paste option.
Use the ribbon instead of a shortcut
If you do not want to memorize the key sequence, Excel offers a menu route. Copy the source range, select a blank destination cell, and choose Home > Paste to open the Paste menu. Select Transpose. Depending on the ribbon layout and window width, Paste may appear as a large button with a dropdown arrow. The Transpose command may also be shown as an icon, so hover over an icon if its label is not visible.
The menu is useful when you want to check what will happen before pasting, or when keyboard accelerators behave differently because of language or customization settings. You can also use the full dialog: choose Home > Paste > Paste Special, select Transpose, and confirm. The dialog offers other paste choices, such as values or formats, that can be combined with transposing when appropriate.
What transpose changes
Transpose swaps the row and column positions of cells. A horizontal header row becomes a vertical list, while a vertical list becomes a row. For a rectangular range, the number of output rows equals the number of source columns, and the number of output columns equals the number of source rows. The order within the range is retained as it rotates: the source’s top row becomes the first output column.
Suppose a small report has months across the top and measures down the side. Transposing the block changes its layout without manually copying each value into a new position. It does not sort the data, reverse its order, or infer a preferred presentation. It simply exchanges row and column coordinates. Any formulas included in the copied cells are pasted as formulas, with references adjusted according to Excel’s normal copy-and-paste behavior.
Paste Special Transpose creates a snapshot. If a source value changes later, the pasted value does not update automatically. This is often ideal for rearranging a report before sending it or for creating a one-time layout. If the destination should stay connected to the original, use the TRANSPOSE function instead.
Choose between Paste Special and the TRANSPOSE function
In Microsoft 365, the TRANSPOSE function can return a rotated range and update when its source changes. With values in A1:C2, enter =TRANSPOSE(A1:C2) in an empty cell such as E1. The formula spills into a three-row-by-two-column result, E1:F3, reflecting the source dimensions. Keep the cells below and to the right of E1 clear so Excel can display the full result.
This formula is a better choice for a report that should respond to edits in the source. It also keeps the transformation visible in the formula bar. In current Microsoft 365, enter the formula in the top-left output cell and press Enter; Excel fills the required area as a dynamic array. The spilled cells are controlled by the formula in E1, so you cannot edit just one of those output cells directly.
In older Excel versions without dynamic arrays, select an output range with the dimensions reversed before entering the formula, then confirm it with Ctrl+Shift+Enter. That creates a legacy array formula. The exact behavior depends on the Excel version, so users on Microsoft 365 generally should use the single-cell entry method rather than the older multi-cell procedure.
- Choose Paste Special for a one-time rearrangement, a standalone copy, or a result you expect to edit independently.
- Choose TRANSPOSE when the output should reflect later changes to the source range.
- Choose a linked formula or other data transformation when you need a more specialized relationship than a simple rotated copy.
What happens to values, formulas, and formatting
A normal Paste Special Transpose generally carries the copied cell contents and formatting into the rotated layout. That can include values, formulas, number formats, fills, borders, and other cell formatting. If you want only part of that information, use the Paste Special dialog’s paste options along with Transpose. For example, pasting values can avoid bringing over formulas, while a formats-only paste can transfer appearance without replacing existing contents.
Formula references deserve a quick check. Copying a formula is not the same as freezing its displayed result: Excel may adjust relative references to suit the new destination, just as it does during an ordinary copy. If the transposed output must contain fixed results, use Paste Special with Values and Transpose rather than assuming a formula will remain unchanged. Absolute references, marked with dollar signs, behave differently from relative references, so inspect important formulas after the operation.
Formatting can also make a correct transpose look unexpected. Column widths and row heights are properties of whole worksheet rows and columns, not just individual cells. Transposing cells does not turn the source column widths into destination row heights or vice versa. If the new layout needs particular widths, adjust them separately after pasting.
Common problems and how to fix them
- The shortcut opens a different command: Use the Paste Special dialog from the Home tab and select Transpose with the mouse. Keyboard accelerators can vary with Excel language, dialog focus, or customized shortcuts.
- The output will not paste: Confirm the destination area is empty and large enough. A two-by-four source requires a four-by-two output area. Existing content in the required cells can block a formula spill or be replaced by a paste.
- You copied the cells but see no result: Click a single destination cell, not a destination range of the original dimensions, then choose Transpose. Excel expands the rotated result from that top-left position.
- The source is a formatted Excel table: A transposed paste is a cell-range operation, not a command that rebuilds the source table’s structured layout. Check headers, table formatting, and formulas in the destination; you may need to create or resize a table afterward.
- The range contains merged cells: Merged cells can prevent a clean transpose or produce an error because their layout does not behave like an ordinary rectangular grid. Unmerge the source cells and arrange the data in a regular range before trying again.
- Some destination cells change unexpectedly: The pasted block may replace existing cells. Undo immediately with Ctrl+Z if the result overwrote something important, then choose a clear destination or make a backup copy first.
Excel on Mac and Excel for the web
On Excel for Mac, the Windows sequence Ctrl+Alt+V, E, Enter is not the matching keyboard shortcut. Use the ribbon’s Home > Paste menu and choose Transpose, or open Paste Special and select the Transpose option. Mac keyboard shortcuts also use Command in many copy-and-paste actions, but the exact Paste Special keystroke can depend on the keyboard and Excel version. The menu avoids relying on a Windows-only key sequence.
In Excel for the web, look for Transpose in the Paste options on the Home tab after copying a range. The web interface can differ from the desktop dialog and may expose fewer Paste Special choices. If the command is not available in the current interface, use the TRANSPOSE formula if supported, or open the workbook in the desktop app. Avoid assuming every desktop shortcut works in a browser, where the browser itself may use some key combinations.
When transposing is useful
Transposing is especially useful when a data source arrives in a layout that does not suit the next task. You might receive one record per column but need one record per row, or need to convert a row of labels into a vertical list for a chart or form. It can also make a small report easier to read when labels are more practical down the side than across the page.
For larger or repeated imports, a one-time paste may not be the best long-term process. If new data arrives regularly, a formula can keep the rotated view current, while Power Query can be a better fit for repeatable transformations and refreshable imports. These approaches have different setup and maintenance requirements; for a quick, one-off rectangular block, Paste Special is usually the simplest.
Frequently Asked Questions
What is the keyboard shortcut to transpose in Excel?
On Windows, copy the range, select the destination, press Ctrl+Alt+V, press E, and press Enter. If E does not select Transpose in your version or language, open Paste Special and click the Transpose checkbox.
Can I transpose data without copying it?
Paste Special Transpose uses copied cells, so copy the range with Ctrl+C before using it. To show a rotated, linked result instead, enter the TRANSPOSE function in a blank cell and leave room for its output.
Does Excel’s transpose shortcut keep the source linked?
No. Paste Special creates a separate pasted result. Use the TRANSPOSE function when changes in the source should flow through to the output.
Can I transpose a row into a column with a formula?
Yes. If the source row is A1:D1, enter =TRANSPOSE(A1:D1) in a blank cell such as F1 in Microsoft 365. The result spills down four rows, F1:F4, and reflects changes to the source.
Why is Transpose unavailable or not working?
Check that a range has been copied, the destination is appropriate, and the source does not contain merged cells that block the operation. If the shortcut sequence is the problem, use Home > Paste > Transpose and select the command directly.
Related
- Resource List Excel Template: Set Up, Track, and Share
- Replace in Excel: Find and Replace Text, Values, and More
- Resize Columns in Excel: Keyboard Shortcuts and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Analysis Extension: ToolPak Setup and UsesExcel’s “Data Analysis” extension usually means the Analysis ToolPak, a free add-in included with desktop Excel that adds…
- Excel Find the Minimum Date With CriteriaTo find the earliest date that meets a condition in Excel, use MINIFS. If dates are in B2:B10…
- Camping Meal Planner Spreadsheet: Plan Meals and Pack FoodA camping meal planner spreadsheet helps you map meals to each day, estimate how much food to bring,…
- Excel Workbook Not Opening? Causes and Fixes for WindowsIf an Excel workbook will not open, first try opening Excel in Safe Mode, then use File >…
- Prevent Duplicates in Google Sheets: 3 Reliable MethodsTo prevent duplicate entries in Google Sheets, select the cells where new values will go, open Data >…
- One Page Landscape in Word: How to Change One PageTo make just one page landscape in Microsoft Word, isolate it in its own section with a section…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.