Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I alphabetize my worksheet?
I have a worksheet which I need to alphabetize according to the name that is
in the first column. However the cells in the whole row all contain information about the last name in the first columns, so they need to be moved according to how the first column is alphabetized. Have I made my question clear? Is there any way to do this automatically on Excel? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I alphabetize my worksheet?
Select your total data range, from A1 to wherever, eg T500. Click on Data
Sort. If you have headings in row 1, make sure that Header row is ticked, else select no header row. If no header row, select to sort by column A, else select to sort by header row of column A, OK out. "Chanie" wrote: I have a worksheet which I need to alphabetize according to the name that is in the first column. However the cells in the whole row all contain information about the last name in the first columns, so they need to be moved according to how the first column is alphabetized. Have I made my question clear? Is there any way to do this automatically on Excel? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I alphabetize my worksheet?
Thanks so much, that was really clear and helpful.
"kassie" wrote: Select your total data range, from A1 to wherever, eg T500. Click on Data Sort. If you have headings in row 1, make sure that Header row is ticked, else select no header row. If no header row, select to sort by column A, else select to sort by header row of column A, OK out. "Chanie" wrote: I have a worksheet which I need to alphabetize according to the name that is in the first column. However the cells in the whole row all contain information about the last name in the first columns, so they need to be moved according to how the first column is alphabetized. Have I made my question clear? Is there any way to do this automatically on Excel? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I alphabetize my worksheet?
My pleasure Chanie!
"Chanie" wrote: Thanks so much, that was really clear and helpful. "kassie" wrote: Select your total data range, from A1 to wherever, eg T500. Click on Data Sort. If you have headings in row 1, make sure that Header row is ticked, else select no header row. If no header row, select to sort by column A, else select to sort by header row of column A, OK out. "Chanie" wrote: I have a worksheet which I need to alphabetize according to the name that is in the first column. However the cells in the whole row all contain information about the last name in the first columns, so they need to be moved according to how the first column is alphabetized. Have I made my question clear? Is there any way to do this automatically on Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best Approach to Worksheet Synchronization | Excel Discussion (Misc queries) | |||
Need data from one worksheet to be in a list in another worksheet. | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
How to Alphabetize Worksheet Tabs? | New Users to Excel | |||
Weekly Transaction Processing | Excel Worksheet Functions |