Sorting Columns

[k f h]

Hi All,

How do I sort columns 1998-2002 to start 2002-1998.
Thanks,
kfh.

 

[Nick Hodge]

Data>Sort..>pick the column and click descending

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

 

[Ragdyer]

Select the row containing the date *AND ALL* the other rows below,
containing the data, then:

<Data> <Sort> <Options>,
Under Orientation, click on "Sort Left To Right",
Then <OK>,
Then, make sure the row containing the dates is in the top sort window,
Then click on "Descending",
Then <OK>.

 

[k f h]

Hi,
Sorry I forgot to mention I am using Excel 2007.
Thanks.

 

[Ragdyer]

That lets me out!<bg>

 

[k f h]

Hi Ragdyer,

You answered my question, I was'nt sorting in decending order. I assumed
this would sort top to botom not right to left.

Cheers,
kfh.