Microsoft Office Tutorials and References
In Depth Information
Using the TRANSPOSE function
3. Type a formula that uses the TRANSPOSE function, with the source range address as its
argument.
In this example, the formula is
=TRANSPOSE(A1:E10)
4. Press Ctrl+Shift+Enter (not just Enter) to create a multicell array formula in all of the selected
cells.
Any changes made in the source range also appear in the transposed range.
Search JabSto ::




Custom Search