Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i arrange column A (last name) in alphabetical order? t.
my phone book is in excel. how can i alphabetize by last name (column A)?
thanks |
#2
|
|||
|
|||
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 "hershy" wrote: my phone book is in excel. how can i alphabetize by last name (column A)? thanks |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide column but show chart | Charts and Charting in Excel | |||
I typed a column in reverse order, how do I flip it (upside down). | Charts and Charting in Excel | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |