1/18/2019 Transpose Data in Excel - Easy Excel Tutorial
Excel Easy
#1 Excel tutorial on the net Excel Introduction Basics Functions Data Analysis VBA 300 Examples Ask us
Transpose Search Entire Site Go
Paste Special Transpose | Transpose Function
Chapter < >
Use the 'Paste Special Transpose' option to switch rows to columns or columns to rows in Excel. You can also
use the TRANSPOSE function. Range
Paste Special Transpose
To transpose data, execute the following steps.
Learn more, it's easy
1. Select the range A1:C1.
AutoFill
2. Right click, and then click Copy.
Fibonacci Sequence
Custom Lists
Comments
Hide Columns or Rows
Skip Blanks
AutoFit
Transpose
Union and Intersect
Flash Fill
Download Excel File
transpose.xlsx
Ad closed by Follow Excel Easy
Report this ad
Why this ad?
Randomly selected
Checklist
3. Select cell E2.
4. Right click, and then click Paste Special.
5. Check Transpose.
https://www.excel-easy.com/examples/transpose.html 1/3
1/18/2019 Transpose Data in Excel - Easy Excel Tutorial
6. Click OK.
Transpose Function
To insert the TRANSPOSE function, execute the following steps.
1. First, select the new range of cells.
2. Type in =TRANSPOSE(
3. Select the range A1:C1 and close with a parenthesis.
4. Finish by pressing CTRL + SHIFT + ENTER.
https://www.excel-easy.com/examples/transpose.html 2/3
1/18/2019 Transpose Data in Excel - Easy Excel Tutorial
Note: The formula bar indicates that this is an array formula by enclosing it in curly braces {}. To delete this array
formula, select the range E2:E4 and press Delete.
Ad closed by
Report this ad
Why this ad?
9/11 Completed! Learn much more about ranges >
Go to Next Chapter: Formulas and Functions
TRANSPOSE • FREE EXCEL HELP • COPYRIGHT (C) 2010-2019 • ALL RIGHTS RESERVED
MICROSOFT EXCEL TUTORIAL | HOW TO USE VBA & MACROS | EXCEL FORMULAS | FUNCTIONS IN EXCEL
https://www.excel-easy.com/examples/transpose.html 3/3
