How reverse the order of columns?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Khoshravan - 14 Aug 2007 10:00 GMT

I have made a table with orientation from right to left.
Now I want to change the direction, in other words I want to reverse the
direction of table.
Is there an easy way to do this job.
Copy/special paste/ transpose doesn't work in this case.

Signature

Rasoul Khoshravan Azar
Kobe University, Kobe, Japan

Reply to this Message

Max - 14 Aug 2007 11:36 GMT

Think you could use a helper row, then select the range and do the Data >
Sort > Options > Sort left to right under "Orientation".

Eg Insert a new row1, fill the numbers: 1,2,3... across your cols range.
Then select the cols range, click Data > Sort > Options. Check "Sort left to
right" under "Orientation" > OK. Then in the Sort dialog, Sort by Row1 >
Descending > OK

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

>
> I have made a table with orientation from right to left.
> Now I want to change the direction, in other words I want to reverse the
> direction of table.
> Is there an easy way to do this job.
> Copy/special paste/ transpose doesn't work in this case.

Reply to this Message

Bob I - 14 Aug 2007 17:40 GMT

Select a column then, r-click and pick Cut, and then select destination
column, r-click select Insert Cut Cells.

> I have made a table with orientation from right to left.
> Now I want to change the direction, in other words I want to reverse the
> direction of table.
> Is there an easy way to do this job.
> Copy/special paste/ transpose doesn't work in this case.

Reply to this Message

Rate this thread: