How reverse the order of columns?

K

Khoshravan

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

Max

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
 
B

Bob I

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