Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Arrange Name,address and other info Alphabetically
I have a sreadsheet with event registation on it ( names, addresses and
telephone ect) the problem is when I put the names in Alphabetical order the other information does not follow? I have used the function that will help me once before and just can not remember what it is..... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Arrange Name,address and other info Alphabetically
Make a copy of your file and learn how to sort in the copy file first.
Select the top-left cell of all the data you want to sort. (Click on that cell) Scroll down and to the right and find the bottom-right cell of all your data. Hold the Shift key down and click on that bottom-right cell. You have now selected all the data you want to sort. Click on Data - Sort in the menu that runs across the top of the screen. Select the column by which you want to sort. Select whether or not the selected data includes a header row. Click OK. Done. HTH Otto "ECR" wrote in message ... I have a sreadsheet with event registation on it ( names, addresses and telephone ect) the problem is when I put the names in Alphabetical order the other information does not follow? I have used the function that will help me once before and just can not remember what it is..... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i arrange alphabetically my sheets? | Excel Worksheet Functions | |||
arrange excel by street address instead of alphabetically by name | Excel Worksheet Functions | |||
How do I arrange worksheets alphabetically in Excel? | Excel Worksheet Functions | |||
How do I arrange the worksheets in my workbook alphabetically? | Excel Worksheet Functions | |||
How do I arrange entries in a column alphabetically | Excel Discussion (Misc queries) |