Sorting Columns
 

Hi All,

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

Sorting Columns
 

DataSort..pick the column and click descending

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
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

"k f h" wrote in message
...
Hi All,

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

Sorting Columns
 

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"k f h" wrote in message
...
Hi All,

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

Sorting Columns
 

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

"Ragdyer" wrote:

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"k f h" wrote in message
...
Hi All,

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

Sorting Columns
 

That lets me out!<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"k f h" wrote in message
...
Hi,
Sorry I forgot to mention I am using Excel 2007.
Thanks.

"Ragdyer" wrote:

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.
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"k f h" wrote in message
...
Hi All,

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

Sorting Columns
 

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.


"k f h" wrote:

Hi All,

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