invert Lines and column on Excel
 

How i can invert Lines / column in Excel
There is way ?
Tks

invert Lines and column on Excel
 

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

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

invert Lines and column on Excel
 

Invert or Transpose?

To transpose, select and copy then paste specialtranspose.

To invert you would need a helper row or column and formulas.


Gord Dibben MS Excel MVP

On Fri, 23 Feb 2007 10:23:15 -0800, Dhfan
wrote:

How i can invert Lines / column in Excel
There is way ?
Tks