I am new to exel and have no clue as how to enter a formula or which one to
use. I want to put in a big directory with dept. names and their new
extensions. Then I want it alphabetized only. Any help would be appreciated
especialli in lame man terms.
Thanks,
Barb

It's easier if you have headers, then just select the whole range and do
data sort and sort ascending by the dep names ( I assume)


--

Regards,

Peo Sjoblom


"Barb" wrote in message
...
I am new to exel and have no clue as how to enter a formula or which one to
use. I want to put in a big directory with dept. names and their new
extensions. Then I want it alphabetized only. Any help would be
appreciated
especialli in lame man terms.
Thanks,
Barb

Hi Barb,
If you are new to Excel, you are probably not aware of the potential
for destroying your data with a sort if you fail to select ALL cells first.
Before invoking the sort select all cells on the worksheet by
using Ctrl+A (3 times in Excel 2007, 2 times in Excel 2002).
Safest to use the Sort from the Data menu, and indicate there
whether you have headers or not (so you don't sort the headers as data).
http://www.mvps.org/dmcritchie/excel/sorting.htm
http://www.mvps.org/dmcritchie/excel...x2k.htm#foobar

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Peo Sjoblom" wrote in message ...
It's easier if you have headers, then just select the whole range and do
data sort and sort ascending by the dep names ( I assume)

"Barb" wrote ...
I am new to Excel and have no clue as how to enter a formula or which one to
use. I want to put in a big directory with dept. names and their new
extensions. Then I want it alphabetized only. Any help would be
appreciated especially inlame man terms.