See this google search result for a few methods.

http://snipr.com/1n6gq

But note my caveat about misspelled words if you go the event code route.


Gord Dibben MS Excel MVP

On Mon, 4 Jun 2007 14:18:02 -0700, Conker10382
wrote:

Did I just coin that term? LOL I would like XL to automatically order
information I enter alphabetically. What sort of options do I have to
accomplish this?