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

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

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

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

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




.

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