View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default Excell 2007: How to arrange cells in a column file alphabetically?

Vince -

Select the column (click on the column letter heading).

On the Data ribbon, click the "Sort A to Z" icon (AZ with a down-pointing
arrow).

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"Vince" wrote in message
...
How can I arrange the data straight down in a column arrange
alphabetically??
For instance I enter the name of all my business contacts in a cell, how
could I make it so that every time I enter a new name, it will file it
alphabetically? Thanks much