How to sort rows alphabetically?

  • Thread starter Thread starter Tom H. Lautenbacher
  • Start date Start date
T

Tom H. Lautenbacher

Hello NG

i have a table with 2 coloums and many rows. in each row there is in column
1 an english expression and in column2 the german translation of it. now i
want to sort the rows alphabetically and according to the english words in
colum1.

e.g. have the following:

COLUMN 1 COLUMN 2
turnover Umsatz
aggregate economy gesamtwirtschaft
net netto
gross brutto
GPD BNP

and I want to get this:
COLUMN 1 COLUMN 2
aggregate economy gesamtwirtschaft
GPD BNP
gross brutto
net netto
turnover Umsatz

can anybody tell me, how to do that?

thanx,
tom.
 
Dave said:
Simply select the range of data you want to sort, then go to
Data>Sort and "sort on" column 1-- it will keep both words aligned
correctly.
Click to expand...

Thanx a lot, Dave!

Cu,
Tom.
 
Simply select the range of data you want to sort, then go to Data>Sort and
"sort on" column 1-- it will keep both words aligned correctly. Be sure you
are selecting both columns before you go to Sort, and watch out for "first
row contains heading" -- you will see what excel thinks is the range you
want to sort (it will sometimes de-select the top row)-- just click "first
row contains heading" on and off to see which one allows you to sort all the
words, without throwing the headings in the mix.
 
Back
Top