Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting excel worksheet
How to sort a column of text alphabetically so that the contents of the
relative rows automatically sort with the column? The A-Z sort function seems only to work with the individual column. Any help, gratefully received. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting excel worksheet
Do not use the A-Z icons for sorting. Instead, highlight the range you
want to sort (which may or may not include a header row), then click Data | Sort and choose the sort field(s) and type (ascend/descend) then click OK. This will keep data on the same rows together. Hope this helps. Pete On Apr 13, 11:12 am, emmcee wrote: How to sort a column of text alphabetically so that the contents of the relative rows automatically sort with the column? The A-Z sort function seems only to work with the individual column. Any help, gratefully received. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting excel worksheet
Select the range that you want to sort, including whichever rows & column
you want sorting, then choose Data/ Sort, and tell it which column to sort by. -- David Biddulph "emmcee" wrote in message ... How to sort a column of text alphabetically so that the contents of the relative rows automatically sort with the column? The A-Z sort function seems only to work with the individual column. Any help, gratefully received. Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting excel worksheet
select all of the cells you want to sort together
either use data-sort or use the tab button to go to the column you want to sort by and use the A-Z button "emmcee" wrote: How to sort a column of text alphabetically so that the contents of the relative rows automatically sort with the column? The A-Z sort function seems only to work with the individual column. Any help, gratefully received. Thanks. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting excel worksheet
For additional help with sorting see
http://www.mvps.org/dmcritchie/excel/sorting.htm but as already pointed out to you the important thing is to select the area to be included in the sort, and do not ever rely of the automatic expansion of a single cell to expand to the current region (Ctrl+SHIFT+*) to actually define the range you want to work with as you will surely destroy you data sooner or later. If you have Excel 2003 or later you cannot rely on Ctrl+A to select all of the cells either, so again you risk destroying your data. If you do have Excel 2003 or later see http://www.mvps.org/dmcritchie/excel...x2k.htm#foobar In using the A-Z sort you might want to insure that the title will sort before the rest of column, as Excel's determination of whether there is a header row involved is very poor, so be aware of what you have and be ready to use Ctrl+Z if the sort does not work. Ctrl+Z will not work if you have used a macro or have an Event macro in place for the worksheet. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "emmcee" wrote in message ... How to sort a column of text alphabetically so that the contents of the relative rows automatically sort with the column? The A-Z sort function seems only to work with the individual column. Any help, gratefully received. Thanks. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting excel worksheet
Many thanks. That solution works
mike (indonesia) "Pete_UK" wrote: Do not use the A-Z icons for sorting. Instead, highlight the range you want to sort (which may or may not include a header row), then click Data | Sort and choose the sort field(s) and type (ascend/descend) then click OK. This will keep data on the same rows together. Hope this helps. Pete On Apr 13, 11:12 am, emmcee wrote: How to sort a column of text alphabetically so that the contents of the relative rows automatically sort with the column? The A-Z sort function seems only to work with the individual column. Any help, gratefully received. Thanks. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting excel worksheet
Many thanks for yr help.
That works. "David Biddulph" wrote: Select the range that you want to sort, including whichever rows & column you want sorting, then choose Data/ Sort, and tell it which column to sort by. -- David Biddulph "emmcee" wrote in message ... How to sort a column of text alphabetically so that the contents of the relative rows automatically sort with the column? The A-Z sort function seems only to work with the individual column. Any help, gratefully received. Thanks. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting excel worksheet
Thanks for feeding back, Mike.
Pete On Apr 16, 12:22 pm, emmcee wrote: Many thanks. That solution works mike (indonesia) "Pete_UK" wrote: Do not use the A-Z icons for sorting. Instead, highlight the range you want to sort (which may or may not include a header row), then click Data | Sort and choose the sort field(s) and type (ascend/descend) then click OK. This will keep data on the same rows together. Hope this helps. Pete On Apr 13, 11:12 am, emmcee wrote: How to sort a column of text alphabetically so that the contents of the relative rows automatically sort with the column? The A-Z sort function seems only to work with the individual column. Any help, gratefully received. Thanks.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting on a protected worksheet in Excel 2000 | Excel Worksheet Functions | |||
Sorting a protected worksheet in Excel 2003 | Excel Discussion (Misc queries) | |||
Sorting a protected worksheet in Excel 3003 | Excel Discussion (Misc queries) | |||
worksheet sorting | Excel Worksheet Functions | |||
Sorting Protected Worksheet | Excel Discussion (Misc queries) |