invert Lines and column on Excel
Probably transpose, as transposition is a kind of inversion.
Anyway, to transpose either:
1) Select the row in question. Copy it, select the top of the column to
which you want to transpose the row, paste special, transpose.
2) Use the TRANSPOSE function (which requires an array formula). Here, you
select an amount of cells equal to the number of cells you want to transpose,
then enter =TRANSPOSE([range to be transposed]) and commit the formula with
CTRL + SHIFT + ENTER.
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"SteveW" wrote:
Do you mean invert or transpose ?
Steve
On Fri, 23 Feb 2007 18:23:15 -0000, Dhfan
wrote:
How i can invert Lines / column in Excel
There is way ?
Tks
|