I don't trust excel to guess the range to be sorted.
I like to select the range (only the last of headers) and then use Data|Sort.
(Sometimes excel guesses wrong and in earlier versions, it doesn't give any
warning message asking if the range should be expanded.)
hershy wrote:
my phone book is in excel. how can i alphabetize by last name (column A)?
thanks
--
Dave Peterson
|