Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 - |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |