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 Transpose in Excel from Horizontal to Vertical 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. Image titled Transpose in Excel from Horizontal to Vertical Step 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.
    Advertisement
  3. Image titled Transpose in Excel from Horizontal to Vertical Step 3
    3
    Enter "=TRANSPOSE(". Type this while you have the cells selected and it will apply to all the cells.
  4. Image titled Transpose in Excel from Horizontal to Vertical Step 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 Transpose in Excel from Horizontal to Vertical Step 5
    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]
    6. Advertisement

You Might Also Like

Transfer Microsoft Office to Another Computer
How to
Transfer Microsoft Office to Another Computer
Unprotect a Word Document Without the Password
How to
Unprotect a Word Document Without the Password
Duplicate a Page in Word4 Simple Ways to Duplicate a Page in Word: Windows & Mac
Install Microsoft OfficeHow to Install Microsoft Office: Subscribe and Download
Print Mirror Image
How to
Print Mirror Image
Change Transparency in PowerPoint
How to
Change Transparency in PowerPoint
Copy a Table from Word
How to
Copy a Table from Word
Send Large Files Through Outlook
How to
Send Large Files Through Outlook
Get Microsoft Office For Free7 Ways to Use Microsoft Office for Free: Web, Mobile, & Desktop Versions
Update Microsoft Office on Mac3 Simple Ways to Update Microsoft Office on a Mac
Insert a Comment Box in Word, PowerPoint, and Excel
How to
Insert a Comment Box in Word, PowerPoint, and Excel
Convert PowerPoint to Word
How to
Convert PowerPoint to Word
Set, Reset, Remove and Recover the Password of Excel Files
How to
Set, Reset, Remove and Recover the Password of Excel Files
Customize the Quick Access Toolbar in Microsoft Word (Windows 7)
How to
Customize the Quick Access Toolbar in Microsoft Word (Windows 7)
Advertisement

References

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

About This Article

Darlene Antonelli, MA
Written by:
Darlene Antonelli, MA
wikiHow Technology Writer
This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for wikiHow. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities. This article has been viewed 9,901 times.
How helpful is this?
Co-authors: 3
Updated: January 3, 2022
Views: 9,901
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?
Advertisement