TRANSPOSE
About : Returns the transpose of an array
Category : Lookup
Location : Built-In
=Transpose(A1:C5) + Ctrl+Shift+Enter
Check out the Excel Shortcut Keys
What Does It Do ?
Location : Built-In
 |
| Transpose Formula |
Check out the Excel Shortcut Keys
What Does It Do ?
This function copies data from a range, and places in it in a new range, turning it so that the data originally in columns is now in rows, and the data originally in rows is in columns.
The transpose range must be the same size as the original range.
The function needs to be entered as an array formula.
To enter an array formula you must first highlight all the cells where the formula is required.
Next type the formula, such as =TRANSPOSE(A1:A5).
Finally press Ctrl+Shift+Enter to confirm it.
If changes need to be made to the formula, the entire array has to be highlighted, the edits can then be made and the Ctrl+Shift+Enter used to confirm it.
Syntax
=TRANSPOSE(Range)
Formatting
No special formatting is needed.
Check out the Excel Shortcut Keys
The transpose range must be the same size as the original range.
The function needs to be entered as an array formula.
To enter an array formula you must first highlight all the cells where the formula is required.
Next type the formula, such as =TRANSPOSE(A1:A5).
Finally press Ctrl+Shift+Enter to confirm it.
If changes need to be made to the formula, the entire array has to be highlighted, the edits can then be made and the Ctrl+Shift+Enter used to confirm it.
Syntax
=TRANSPOSE(Range)
Formatting
No special formatting is needed.
Check out the Excel Shortcut Keys
No comments:
Post a Comment