Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sort Trouble
For some reason I'm not getting the sort to work like I need it to.
I mark one cell and click on Sort Ascending and it sorts that column (only) but doesn't take along the rest of the row. Do I have some setting wrong or something else? Thanks in advance. Doug |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sort Trouble
Doug
What you are doing when you select one cell and sort, is to tell Excel to guess the range you want sorted. Excel did and it's guess is not what you wanted. Excel's rules on setting the sort range involves blank rows and columns. Sometimes it works and sometimes it doesn't. What you should do is never allow Excel to set the range you want sorted. You do this by selecting the range you want sorted, then do Data - Sort. Works every time. Come back if this doesn't work for you. HTH Otto "Doug Mc" wrote in message ... For some reason I'm not getting the sort to work like I need it to. I mark one cell and click on Sort Ascending and it sorts that column (only) but doesn't take along the rest of the row. Do I have some setting wrong or something else? Thanks in advance. Doug |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sort Trouble
By selecting the range do you mean to mark all the cells in that particular
column - or what? Thanks, Doug "Otto Moehrbach" wrote in message ... Doug What you are doing when you select one cell and sort, is to tell Excel to guess the range you want sorted. Excel did and it's guess is not what you wanted. Excel's rules on setting the sort range involves blank rows and columns. Sometimes it works and sometimes it doesn't. What you should do is never allow Excel to set the range you want sorted. You do this by selecting the range you want sorted, then do Data - Sort. Works every time. Come back if this doesn't work for you. HTH Otto "Doug Mc" wrote in message ... For some reason I'm not getting the sort to work like I need it to. I mark one cell and click on Sort Ascending and it sorts that column (only) but doesn't take along the rest of the row. Do I have some setting wrong or something else? Thanks in advance. Doug |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sort Trouble
Pre-select all the columns you want included in the sort.
Or if you wanted to sort only 25 rows in 5 columns, select A1:E25 or whatever range you choose. Gord Dibben MS Excel MVP On Wed, 16 Dec 2009 09:56:42 -0600, "Doug Mc" wrote: By selecting the range do you mean to mark all the cells in that particular column - or what? Thanks, Doug "Otto Moehrbach" wrote in message ... Doug What you are doing when you select one cell and sort, is to tell Excel to guess the range you want sorted. Excel did and it's guess is not what you wanted. Excel's rules on setting the sort range involves blank rows and columns. Sometimes it works and sometimes it doesn't. What you should do is never allow Excel to set the range you want sorted. You do this by selecting the range you want sorted, then do Data - Sort. Works every time. Come back if this doesn't work for you. HTH Otto "Doug Mc" wrote in message ... For some reason I'm not getting the sort to work like I need it to. I mark one cell and click on Sort Ascending and it sorts that column (only) but doesn't take along the rest of the row. Do I have some setting wrong or something else? Thanks in advance. Doug |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sort Trouble
Doug, yes, that is what is meant.
When performing the sort highlight ALL the data that you want included (rows and columns); that works for me 100% of the time. Please hit Yes if my comments have helped. Thanks. "Doug Mc" wrote: By selecting the range do you mean to mark all the cells in that particular column - or what? Thanks, Doug "Otto Moehrbach" wrote in message ... Doug What you are doing when you select one cell and sort, is to tell Excel to guess the range you want sorted. Excel did and it's guess is not what you wanted. Excel's rules on setting the sort range involves blank rows and columns. Sometimes it works and sometimes it doesn't. What you should do is never allow Excel to set the range you want sorted. You do this by selecting the range you want sorted, then do Data - Sort. Works every time. Come back if this doesn't work for you. HTH Otto "Doug Mc" wrote in message ... For some reason I'm not getting the sort to work like I need it to. I mark one cell and click on Sort Ascending and it sorts that column (only) but doesn't take along the rest of the row. Do I have some setting wrong or something else? Thanks in advance. Doug . |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sort Trouble
Thanks to all of you for your help.
I appreciate it. Doug "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Pre-select all the columns you want included in the sort. Or if you wanted to sort only 25 rows in 5 columns, select A1:E25 or whatever range you choose. Gord Dibben MS Excel MVP On Wed, 16 Dec 2009 09:56:42 -0600, "Doug Mc" wrote: By selecting the range do you mean to mark all the cells in that particular column - or what? Thanks, Doug "Otto Moehrbach" wrote in message ... Doug What you are doing when you select one cell and sort, is to tell Excel to guess the range you want sorted. Excel did and it's guess is not what you wanted. Excel's rules on setting the sort range involves blank rows and columns. Sometimes it works and sometimes it doesn't. What you should do is never allow Excel to set the range you want sorted. You do this by selecting the range you want sorted, then do Data - Sort. Works every time. Come back if this doesn't work for you. HTH Otto "Doug Mc" wrote in message ... For some reason I'm not getting the sort to work like I need it to. I mark one cell and click on Sort Ascending and it sorts that column (only) but doesn't take along the rest of the row. Do I have some setting wrong or something else? Thanks in advance. Doug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
sort & expand trouble | Excel Discussion (Misc queries) | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
how can I hide sort ascending and sort descending options in the . | Excel Discussion (Misc queries) |