Hi,

Is there any way to convert the column order?

For example:

ColumnA;ColumnB;ColumnC;ColumnD;....

How to have like the inverse order:

.....;ColumnD;ColumnC;ColumnB;ColumnA

Nota: If there's any formula, it should be keeped


Thank you very much in advance

A bit more explanation might help

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"mobimus" <(E-Mail Removed)@enlever> wrote in message
news:mn.53187d5c55529142.43543@enlever...
> Hi,
>
> Is there any way to convert the column order?
>
> For example:
>
> ColumnA;ColumnB;ColumnC;ColumnD;....
>
> How to have like the inverse order:
>
> ....;ColumnD;ColumnC;ColumnB;ColumnA
>
> Nota: If there's any formula, it should be keeped
>
>
> Thank you very much in advance
>
>

> A bit more explanation might help
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "mobimus" <(E-Mail Removed)@enlever> wrote in message
> news:mn.53187d5c55529142.43543@enlever...
>> Hi,
>>
>> Is there any way to convert the column order?
>>
>> For example:
>>
>> ColumnA;ColumnB;ColumnC;ColumnD;....
>>
>> How to have like the inverse order:
>>
>> ....;ColumnD;ColumnC;ColumnB;ColumnA
>>
>> Nota: If there's any formula, it should be keeped
>>
>>
>> Thank you very much in advance
>>
>>

Ok,

You suppose that you have 4 columns in the foloowing order: A(Name);
B(LastName); C(Grade); D(Marks).

Now, I would like to have colmuns in the inverse order, like:
D(Marks); C(Grade); B(LastName);A(Name)

I hope it's more clear now

I'm waiting for your help

highlight your columns>data>sort>descending>options>left to right

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"mobimus" <(E-Mail Removed)@enlever> wrote in message
news:mn.533c7d5c62001116.43543@enlever...
>> A bit more explanation might help
>>
>> --
>> Don Guillett
>> SalesAid Software
>> (E-Mail Removed)
>> "mobimus" <(E-Mail Removed)@enlever> wrote in message
>> news:mn.53187d5c55529142.43543@enlever...
>>> Hi,
>>>
>>> Is there any way to convert the column order?
>>>
>>> For example:
>>>
>>> ColumnA;ColumnB;ColumnC;ColumnD;....
>>>
>>> How to have like the inverse order:
>>>
>>> ....;ColumnD;ColumnC;ColumnB;ColumnA
>>>
>>> Nota: If there's any formula, it should be keeped
>>>
>>>
>>> Thank you very much in advance
>>>
>>>
>
> Ok,
>
> You suppose that you have 4 columns in the foloowing order: A(Name);
> B(LastName); C(Grade); D(Marks).
>
> Now, I would like to have colmuns in the inverse order, like:
> D(Marks); C(Grade); B(LastName);A(Name)
>
> I hope it's more clear now
>
> I'm waiting for your help
>
>

You could also select the column you want to move and shift-click on one of its
borders. Then drag it to its new position. (let go of the mouse button before
you let go of the shift key.)



mobimus wrote:
>
> Hi,
>
> Is there any way to convert the column order?
>
> For example:
>
> ColumnA;ColumnB;ColumnC;ColumnD;....
>
> How to have like the inverse order:
>
> ....;ColumnD;ColumnC;ColumnB;ColumnA
>
> Nota: If there's any formula, it should be keeped
>
> Thank you very much in advance

--

Dave Peterson

You cannot change the letter associated with a column. A is by definition the
leftmost column, B the second one from the left, etc. So no, you cannot have
D(Marks); C(Grade); B(LastName);A(Name)
But you rearrange the data that appears in each column, like this:
A(Marks); B(Grade); C(LastName);D(Name)
See DOn Peterson's post for instructions on moving columns around the
worksheet.
--
Ted

To reverse the data order in the columns.........

Assuming 6 columns

Insert a row at top of range.

Enter the numbers 1 to 6 across.

Select the columns then Data>Sort>Options>Sort left to right.

Sort on the row with numbers in Descending order.


Gord Dibben Excel MVP

On Sat, 10 Dec 2005 13:12:37 GMT, "mobimus" <(E-Mail Removed)@enlever> wrote:

>Hi,
>
>Is there any way to convert the column order?
>
>For example:
>
>ColumnA;ColumnB;ColumnC;ColumnD;....
>
>How to have like the inverse order:
>
>....;ColumnD;ColumnC;ColumnB;ColumnA
>
>Nota: If there's any formula, it should be keeped
>
>
>Thank you very much in advance
>