Microsoft Excel 2007 with Example

1 Introduction

1.8 Transpose

Paste Special Transpose , Transpose Function

Use the 'Paste Special Transpose' option to switch rows to columns or columns to rows in Excel. You can also use the TRANSPOSE function.

Paste Special Transpose

To transpose data, execute the following steps.

1. Select the range A1:C1.

2. Right click, and then click Copy.

Right Click Copy

3. Select cell E2.

4. Right click, and then click Paste Special...

5. Check Transpose.

Check Transpose

6. Click OK.

Paste Special Transpose Result

Transpose Function

To insert the TRANSPOSE function, execute the following steps.

1. First, select the new range of cells.

Select the New Range

2. Type in =TRANSPOSE(

3. Select the range A1:C1 and close with a parenthesis.

Transpose Function

4. Finish by pressing CTRL + SHIFT + ENTER.

Transpose Function Result

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.