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("A1"), order1:=xlAscending,
header:=xlGuess
End If
End Sub

"tonya" wrote in message
...
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 DataSort and then specify to "Sort On" Col A and "Ascending".


--
neopolitan


------------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=499403

I think you need to give us some more details about your data and what you
want sorted.


***********
Regards,
Ron

XL2002, WinXP-Pro


"tonya" wrote:

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

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

It's automatic after you click a rectangle.

tonya wrote:

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

--

Dave Peterson