Prev: Formula Help
Next: how do I convert pace per mile to total time in minutes in excel?
From: Mahmoud Mustafa on 4 May 2010 23:56
I'm Mahmoud from Egypt
and recently joined to ur group
I have a problem with excel file , and need help from u or anyone can help
to solve the problem

I have a dictionary excel file contains 2 columns in about 40 pages
now I need to sort all the data alphbetic


the problem is I can sort only one column and cann't sort the second one
... I tried to put all words in one column and made sort ...but the problem
now I can not devide the words of the dictionary file into 2 columns

can u help me
Thanks
Mahmoud
From: ozgrid.com on 5 May 2010 00:09
Data>Sort by Column A and then by Column B as the second sort Column.


--
Regards
Dave Hawley
www.ozgrid.com
"Mahmoud Mustafa" <MahmoudMustafa(a)discussions.microsoft.com> wrote in
message news:9F8B7071-34FD-4097-B88A-0604C3508D89(a)microsoft.com...
> I'm Mahmoud from Egypt
> and recently joined to ur group
> I have a problem with excel file , and need help from u or anyone can help
> to solve the problem
>
> I have a dictionary excel file contains 2 columns in about 40 pages
> now I need to sort all the data alphbetic
>
>
> the problem is I can sort only one column and cann't sort the second one
> .. I tried to put all words in one column and made sort ...but the problem
> now I can not devide the words of the dictionary file into 2 columns
>
> can u help me
> Thanks
> Mahmoud

From: Dave Peterson on 5 May 2010 08:24
I'd put all the data in one column, do the sort, then split the data again.

Another alternative would be to put the data into MSWord. It has some nice
formatting features (including using multiple columns for displaying your list
of words). And MSWord allows you to sort that list, too.

Mahmoud Mustafa wrote:
>
> I'm Mahmoud from Egypt
> and recently joined to ur group
> I have a problem with excel file , and need help from u or anyone can help
> to solve the problem
>
> I have a dictionary excel file contains 2 columns in about 40 pages
> now I need to sort all the data alphbetic
>
> the problem is I can sort only one column and cann't sort the second one
> .. I tried to put all words in one column and made sort ...but the problem
> now I can not devide the words of the dictionary file into 2 columns
>
> can u help me
> Thanks
> Mahmoud

--

Dave Peterson
 | 
Pages: 1
Prev: Formula Help
Next: how do I convert pace per mile to total time in minutes in excel?