If you only want one copy of the list, then you would need to select the list
and do Data=>Sort.

--
Regards,
Tom Ogilvy


"ROSEANN" wrote:

> I AM WORKING ON AN EXCEL SPREADSHEET THAT WILL LIST ABOUT A 100 NAMES. I WANT
> THESE NAMES FORMATTED ALPHABETICALLY. IS THERE A FUNCTION THAT WILL DO THIS
> AUTOMATICALLY?
> THANKS.