software

In excel how do I get my rows under column A to automatically alphabetize

Right/click the sheet tab, select View Code, enter this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Columns(1).Sort key1:=Range(quot;A1quot;), order1:=xlAscending,
header:=xlGuess
End If
End Sub

quot;tonyaquot; gt; wrote in message
...
gt; In excel how do I get my rows under column A to automatically alphabetize

Select all cells containing data (for example: A2-G25).
Click on Datagt;Sort and then specify to quot;Sort Onquot; Col A and quot;Ascendingquot;.--
neopolitan------------------------------------------------------------------------
neopolitan's Profile: www.excelforum.com/member.php...nfoamp;userid=611
View this thread: www.excelforum.com/showthread...hreadid=499403I think you need to give us some more details about your data and what you
want sorted.***********
Regards,
Ron

XL2002, WinXP-Proquot;tonyaquot; wrote:

gt; In excel how do I get my rows under column A to automatically alphabetize

Maybe:
contextures.com/xlSort02.html
from Debra Dalgleish's site.

It's automatic after you click a rectangle.

tonya wrote:
gt;
gt; In excel how do I get my rows under column A to automatically alphabetize

--

Dave Peterson