Use 3 columns.

Column A = DVD Name.......The Bridges of Madison County

Column B = Type of Movie.......Romance

Column C = Actors.........Clint Eastwood, Meryl Streep.

Enter your data then select all columns and sort by DVD column in Ascending
order.

This is not "automatic" but comes pretty close.


Gord Dibben Excel MVP


On 8 Apr 2005 21:39:36 -0700, "chamaman" wrote:

I am making a list of all my DVD's, Cd's and etc. I want to be able to
type in the following information in a non Alphabetized order and have
Excel automatically put the list in Alphabetical order. Then as I ad
items to the list it will automatically put them in Alphabetical order.
Is this possible? Do I have to use 1 cell or 3 cells?
Any and all advise will be greatly appreciated.
DVD name Type of Movie Actors
DVD name Type of Movie Actors
DVD name Type of Movie Actors
Thanks,
Chamaman