If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
alphabetize entire rows by first word of first column
I want to make a list of names and addresses putting name, address, city,
state, zip across in separate columns. Is there a way to attach these so that when I alphabetize the names each of the cells in the row stay with the correct person? |
#2
|
|||
|
|||
alphabetize entire rows by first word of first column
When you go to alphabatize, aka sort the data, make sure you select ALL of
the columns. -- Best Regards, Luke M "Cindy Sue" Cindy wrote in message ... I want to make a list of names and addresses putting name, address, city, state, zip across in separate columns. Is there a way to attach these so that when I alphabetize the names each of the cells in the row stay with the correct person? |
#3
|
|||
|
|||
alphabetize entire rows by first word of first column
Hi,
When you do the sort select ALL the columns then in the sort wizard select the column to sort on (Name) and all the data will stay in their respective rows -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Cindy Sue" wrote: I want to make a list of names and addresses putting name, address, city, state, zip across in separate columns. Is there a way to attach these so that when I alphabetize the names each of the cells in the row stay with the correct person? |
#4
|
|||
|
|||
alphabetize entire rows by first word of first column
Cindy Sue -
There are two basic ways. First, you can just select the entire range before sorting, and all rows will remain together. Second, you can add an AutoFilter to the data and when you sort a column, all the other columns sort with it, keeping the records together. -- Daryl S "Cindy Sue" wrote: I want to make a list of names and addresses putting name, address, city, state, zip across in separate columns. Is there a way to attach these so that when I alphabetize the names each of the cells in the row stay with the correct person? |
#5
|
|||
|
|||
alphabetize entire rows by first word of first column
Just make sure you select ALL the columns containing info before sorting.
Cindy Sue wrote: I want to make a list of names and addresses putting name, address, city, state, zip across in separate columns. Is there a way to attach these so that when I alphabetize the names each of the cells in the row stay with the correct person? |
#6
|
|||
|
|||
alphabetize entire rows by first word of first column
Select the entire table, goto Data Sort Sort on 'Name' column.
Hopes this helps. .... Per "Cindy Sue" Cindy skrev i meddelelsen ... I want to make a list of names and addresses putting name, address, city, state, zip across in separate columns. Is there a way to attach these so that when I alphabetize the names each of the cells in the row stay with the correct person? |
Thread Tools | |
Display Modes | |
|
|