Fliping the values in columns

[thrava]

Hi

I have values in columns A to ...say G.
I want to quickly (without retyping the values) flip the order so that what
is now in column A appears in column G, what is now in B appear in F etc.
How can this be done quickly please?

thanks

 

[Peo Sjoblom]

Insert a new row on top, put 1 in A1, 2 in B2 and so to G1, select all
values plus the newly inserted values in A1:G1, do data>sort, click options
and select left to right, sort by row 1 and choose descending

 

[galimi]

The quickest, non-programmatic way to accomplish this is to place sequential
numbers below your values and sort descending. You can also accomplish this
programmatically.