LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default 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 -



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting on a protected worksheet in Excel 2000 RS Excel Worksheet Functions 0 October 28th 06 03:56 AM
Sorting a protected worksheet in Excel 2003 drusilas Excel Discussion (Misc queries) 0 December 28th 05 11:15 PM
Sorting a protected worksheet in Excel 3003 drusilas Excel Discussion (Misc queries) 0 December 28th 05 11:14 PM
worksheet sorting sisco98 Excel Worksheet Functions 5 July 22nd 05 02:44 PM
Sorting Protected Worksheet Vonner Excel Discussion (Misc queries) 1 July 16th 05 03:23 PM


All times are GMT +1. The time now is 10:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"