Sunday 23 April 2017

Excel - Microsoft Excel Transpose Function

Description

The Excel Transpose function 'transposes' an array of cells (ie. the function copies a horizontal range of cells into a vertical range and vice versa). 

Array Formulas: 

To input an array formula, you need to first highlight the range of cells for the function result. Type your function into the first cell of the range, and press CTRL-SHIFT-Enter.

Go to the Excel Array Formulas page for more details. 

The format of the function is : 

TRANSPOSE( array ) 

Where the array argument is a range of Excel spreadsheet cells. 

As the transpose function returns an array of values, it must be entered as an Array Formula. 

No comments:

Post a Comment