How to convert column order?

M

mobimus

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
 
M

mobimus

A bit more explanation might help
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 :)
 
D

Dave Peterson

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.)
 
T

TedMi

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.
 
G

Gord Dibben

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
 
Top