View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AwfulTruth AwfulTruth is offline
external usenet poster
 
Posts: 1
Default Sorting Issue - Any help?

I am using Excel 2003 SP2 for managing my address list.
When I select col 1 and and press sorting button A-Z , it ask for
expanding selectoin, On hitting YES,
it does sorting but in two groups.

e.g.
Row 1 to Row 700, first groups from A to Z
then
Row 701 to 856 again from A to Z.

I want to sort all my records from A to Z.

What could be issue here?

Thanks in advance....