alphabetizing rows automatically

[tonya]

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

[neopolitan]

Select all cells containing data (for example: A2-G25).
Click on Data>Sort and then specify to "Sort On" Col A and "Ascending".

[Bob Umlas]

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" <[email protected]> wrote in message
news:[email protected]...
> In excel how do I get my rows under column A to automatically alphabetize

[Ron Coderre]

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

[Dave Peterson]

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