View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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