Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell 2007: How to arrange cells in a column file alphabetically?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell 2007: How to arrange cells in a column file alphabetically?
You can either sort the data manually or have a macro sort it automatically
whenever the data in the column is modified. -- Gary''s Student - gsnu200817 "Vince" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell 2007: How to arrange cells in a column file alphabetica
If the designated data is all in column A and down, what would be the Macro?
Thanks "Gary''s Student" wrote: You can either sort the data manually or have a macro sort it automatically whenever the data in the column is modified. -- Gary''s Student - gsnu200817 "Vince" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell 2007: How to arrange cells in a column file alphabetically?
The simplest thing is to re-sort every so often but others may offer you a
VBA solution best wishes Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell 2007: How to arrange cells in a column file alphabetica
hi,
select entire names and key as alt+d and enter. "Bernard Liengme" wrote: The simplest thing is to re-sort every so often but others may offer you a VBA solution best wishes Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell 2007: How to arrange cells in a column file alphabetica
Hi,
After I select all the cells, where do I enter "alt+d and enter"? in the actual fx window? "raghav" wrote: hi, select entire names and key as alt+d and enter. "Bernard Liengme" wrote: The simplest thing is to re-sort every so often but others may offer you a VBA solution best wishes Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell 2007: How to arrange cells in a column file alphabetica
When you select all of the cells and then immediately hit [Alt]+[D] followed
by [Enter] it is the same as going to Data | Sort. What will happen next is that a dialog will open up to gather a little more about how to sort the selected cells. You can probably just hit the [Enter] key or click the [OK] button on that dialog to continue. If you have related data in other columns on the same row with the names, make sure you select all of the data in all rows/columns so that when you do sort it, the related data on the rows goes with the names as they are sorted. "Vince" wrote: Hi, After I select all the cells, where do I enter "alt+d and enter"? in the actual fx window? "raghav" wrote: hi, select entire names and key as alt+d and enter. "Bernard Liengme" wrote: The simplest thing is to re-sort every so often but others may offer you a VBA solution best wishes Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell 2007: How to arrange cells in a column file alphabetically?
I would recommend you do use event code to sort automatically as you enter
names. Very difficult to track any errors in input once the sort has taken place. Make sure the name and info is correct then sort manually as others have posted. Gord Dibben MS Excel MVP On Thu, 4 Dec 2008 12:52:01 -0800, Vince wrote: 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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell 2007: How to arrange cells in a column file alphabetica
I think Gord left out a small word ... "not" between "I would recommend you
do" and "use event code..." as that would seem to go along with the rest of his logic, which I tend to agree with - especially if the list is long at all. "Gord Dibben" wrote: I would recommend you do use event code to sort automatically as you enter names. Very difficult to track any errors in input once the sort has taken place. Make sure the name and info is correct then sort manually as others have posted. Gord Dibben MS Excel MVP On Thu, 4 Dec 2008 12:52:01 -0800, Vince wrote: 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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell 2007: How to arrange cells in a column file alphabetica
NOT! NOT!
Thanks for picking that up Jerry Gord On Thu, 4 Dec 2008 16:30:05 -0800, JLatham <HelpFrom @ Jlathamsite.com.(removethis) wrote: I think Gord left out a small word ... "not" between "I would recommend you do" and "use event code..." as that would seem to go along with the rest of his logic, which I tend to agree with - especially if the list is long at all. "Gord Dibben" wrote: I would recommend you do use event code to sort automatically as you enter names. Very difficult to track any errors in input once the sort has taken place. Make sure the name and info is correct then sort manually as others have posted. Gord Dibben MS Excel MVP On Thu, 4 Dec 2008 12:52:01 -0800, Vince wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i arrange alphabetically my sheets? | Excel Worksheet Functions | |||
can I arrange folders/workbooks alphabetically? | Excel Discussion (Misc queries) | |||
How do I arrange columns alphabetically by column label? | Excel Worksheet Functions | |||
How do you arrange text alphabetically in a column? | New Users to Excel | |||
How do I arrange entries in a column alphabetically | Excel Discussion (Misc queries) |