Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
invert Lines and column on Excel
How i can invert Lines / column in Excel
There is way ? Tks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I invert a column of numbers? (make the 1st last, etc) | Excel Discussion (Misc queries) | |||
reverse or invert column data | Excel Worksheet Functions | |||
how do you invert a column | Excel Discussion (Misc queries) | |||
How do I invert a column in Excel? | Excel Discussion (Misc queries) | |||
Invert Excel Selection | Excel Discussion (Misc queries) |