How to Transpose in Excel from Horizontal to Vertical

While you're working in Excel, you might notice that the data you have in horizontal cells might make more sense in vertical cells. You can use the copy and paste/transpose method, but that might result in duplicate data. This wikiHow will teach you how to transpose in Excel using the TRANSPOSE function.

Steps

  1. Image titled Add Error Bars in Excel on PC or Mac Step 1
    1
    Open your document in Excel. You can find this program in your Start Menu or Applications Folder.
    • You can either open your document from Excel by clicking Open from the File tab, or you can right-click the file in your file browser and click Open With.
  2. 2
    Select blank cells that mirror the same amount of your original cell set. For example, if you have 4 cells of data presented vertically that you want to display horizontally and 4 cells of data you have horizontal that you want vertical, make sure you select the same amount of blank cells (8) so they can be transposed.
  3. 3
    Enter "=TRANSPOSE(". Type this while you have the cells selected and it will apply to all the cells.
  4. 4
    Type the range of cells you want to transpose. For example, if the 8 cells of data are in A1-B4, you'll enter "=TRANSPOSE(A1:B4)".
    • Don't press Enter/Return yet.
  5. Image titled Achieve Tax Relief from IRS Step 7
    5
    Press Ctrl+⇧ Shift+↵ Enter. Since you're using an array formula (which is a formula that gets applied to more than one cell), you'll need to press Ctrl + Shift + Enter instead of just Enter.[1]

You Might Also Like

Transfer Microsoft Office to Another Computer
How to
Transfer Microsoft Office to Another Computer
Install Microsoft Teams on Windows
How to
Install Microsoft Teams on Windows
Unprotect a Word Document Without the Password
How to
Unprotect a Word Document Without the Password
Install Microsoft Teams on a Mobile Device
How to
Install Microsoft Teams on a Mobile Device
Get Microsoft Office For Free
How to
Get Microsoft Office For Free
Change Your Background in Microsoft Teams
How to
Change Your Background in Microsoft Teams
Change Microsoft Office Product Key
How to
Change Microsoft Office Product Key
Install Microsoft Office
How to
Install Microsoft Office
Activate Microsoft Office 2010
How to
Activate Microsoft Office 2010
Print Mirror Image
How to
Print Mirror Image
Update Microsoft Office on Mac
How to
Update Microsoft Office on Mac
Convert PowerPoint to Word
How to
Convert PowerPoint to Word
Copy a Table from Word
How to
Copy a Table from Word
Install Microsoft Office 2007
How to
Install Microsoft Office 2007

References

  1. ↑ https://support.microsoft.com/en-us/office/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027

About This Article

wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time.
How helpful is this?
Co-authors: 3
Updated: December 23, 2021
Views: 55
Categories: Microsoft Office
Article SummaryX

1. Open your document in Excel.
2. Select blank cells that mirror the same amount of your original cell set.
3. Enter "=TRANSPOSE(."
4. Type the range of cells you want to transpose.
5. Press Ctrl + Shift + Enter.

Did this summary help you?