D
Dhfan
How i can invert Lines / column in Excel
There is way ?
Tks
There is way ?
Tks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
SteveW
Do you mean invert or transpose ?
Steve
Steve
D
Dave F
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
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
G
Gord Dibben
Invert or Transpose?
To transpose, select and copy then paste special>transpose.
To invert you would need a helper row or column and formulas.
Gord Dibben MS Excel MVP
To transpose, select and copy then paste special>transpose.
To invert you would need a helper row or column and formulas.
Gord Dibben MS Excel MVP