Download Article
Download Article
This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. Darlene has been writing and editing tech content at wikiHow since 2019. She previously worked for AppleCare, served as a writing tutor, volunteered in IT at an animal rescue, and taught as an adjunct professor for EN101 and EN102. Darlene has completed Coursera courses on technology, writing, and language. She holds both a BA (2011) and an MA (2012) from Rowan University in Writing, with a focus on workplace communication. With her extensive experience, academic background, and ongoing learning, Darlene has become the go-to grammar expert for her friends and family, as well as a skilled wordsmith for anyone in need.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 42,252 times.
Learn more...
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.
Things You Should Know
- Start by selecting blank cells that mirror the same amount as your original cell set.
- Enter "
=TRANSPOSE(" to apply the function to all selected cells. - Press Ctrl+⇧ Shift+↵ Enter to run the function.
Steps
Download Article
-
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.
-
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 -
Enter "=TRANSPOSE(". Type this while you have the cells selected and it will apply to all the cells. -
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.
-
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]- If you don't like those results, you can try using the copy and paste/transpose method.
Expert Q&A
Tips
References
About This Article
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.
Is this article up to date?
