how do i arrange column A (last name) in alphabetical order? t.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

my phone book is in excel. how can i alphabetize by last name (column A)?

thanks
 
Click on any one last name.
Then, Look for the Sort Ascending Button on the Standard Toolbar. It looks
like a Blue A above a Red Z. Click that button once.
--or--
Click on any cell in the phone list (such as a last name).
Go to Data | Sort.
Make sure it is selecting the Last Name Column in the Sort by position.
Click Okay.

tj
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

last name alphabetical order 3
How do I arrange cells in alphabetical order in Excel? 2
how do I arrange names in alphabetic order in an excel sheet 2
Excell 2007: How to arrange cells in a column file alphabetically? 10
How do I separate first and last names into two columns? 2
Paste records that overflow to new column on same page 8
How to type each letter of the alphabet automatically in a specific color in Word? 0
Alphabetize in multiple columns 2

Back
Top