software

When attempting to sort data, newly entered data seems to stay the same while
the old data sorts itself. I have one whole column that is now mismatched.
I am a newbie to this program so I am sure I am doing not doing something
basic.

BillBob:

If you want to sort a multi-column range of cells:

Select the entire range of cells
lt;datagt;lt;sortgt;
Set your sort parameters
Click the [OK] button.

If all of the relevant columns are not pre-selected, they will not sort with
the column you want sorted and you'll have out-of-sync mess.

Does that help?
***********
Regards,
Ron

XL2002, WinXPquot;BillyBobquot; wrote:

gt; When attempting to sort data, newly entered data seems to stay the same while
gt; the old data sorts itself. I have one whole column that is now mismatched.
gt; I am a newbie to this program so I am sure I am doing not doing something
gt; basic.

Thank you for your help Ron. When I go to Data - Sort - I do not seem to
have an option through which I can set the perameters. I am left with a
dialogue box which reads quot;lists sort byquot; and quot;then byquot; and quot;then byquot;. When I
go into the pull down menus all I am given an option of is which columns to
sort. A quot;blue boxquot; is evident on the data - but I don't know how to expand
this box to include the new data. When I try to expand the box it simplly
drops the old infomation on top of the new and overwrites it. So, the
question is how do I set source perameters - where do I need to look?

Thanks
BillyBob

quot;Ron Coderrequot; wrote:

gt; BillBob:
gt;
gt; If you want to sort a multi-column range of cells:
gt;
gt; Select the entire range of cells
gt; lt;datagt;lt;sortgt;
gt; Set your sort parameters
gt; Click the [OK] button.
gt;
gt; If all of the relevant columns are not pre-selected, they will not sort with
gt; the column you want sorted and you'll have out-of-sync mess.
gt;
gt; Does that help?
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP
gt;
gt;
gt; quot;BillyBobquot; wrote:
gt;
gt; gt; When attempting to sort data, newly entered data seems to stay the same while
gt; gt; the old data sorts itself. I have one whole column that is now mismatched.
gt; gt; I am a newbie to this program so I am sure I am doing not doing something
gt; gt; basic.

It seems like you're not performing the first step:
Select ALL of the data in the range, not just the column you want sorted.

Example
If you have data in the range A1100 and you want to sort that range by
Col_B in ascending order:

Select A1100
lt;datagt;lt;sortgt;
Sort by: Column B
Check: Ascending
Click the [OK] button

That would sort A1100 by Col_B, keeping the corresponding records
associated with each Col_B item together with the item.

Does that help? or am I missing something?
***********
Regards,
Ron

XL2002, WinXPquot;BillyBobquot; wrote:

gt; Thank you for your help Ron. When I go to Data - Sort - I do not seem to
gt; have an option through which I can set the perameters. I am left with a
gt; dialogue box which reads quot;lists sort byquot; and quot;then byquot; and quot;then byquot;. When I
gt; go into the pull down menus all I am given an option of is which columns to
gt; sort. A quot;blue boxquot; is evident on the data - but I don't know how to expand
gt; this box to include the new data. When I try to expand the box it simplly
gt; drops the old infomation on top of the new and overwrites it. So, the
gt; question is how do I set source perameters - where do I need to look?
gt;
gt; Thanks
gt; BillyBob
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; BillBob:
gt; gt;
gt; gt; If you want to sort a multi-column range of cells:
gt; gt;
gt; gt; Select the entire range of cells
gt; gt; lt;datagt;lt;sortgt;
gt; gt; Set your sort parameters
gt; gt; Click the [OK] button.
gt; gt;
gt; gt; If all of the relevant columns are not pre-selected, they will not sort with
gt; gt; the column you want sorted and you'll have out-of-sync mess.
gt; gt;
gt; gt; Does that help?
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP
gt; gt;
gt; gt;
gt; gt; quot;BillyBobquot; wrote:
gt; gt;
gt; gt; gt; When attempting to sort data, newly entered data seems to stay the same while
gt; gt; gt; the old data sorts itself. I have one whole column that is now mismatched.
gt; gt; gt; I am a newbie to this program so I am sure I am doing not doing something
gt; gt; gt; basic.

Ron Coderre wrote:
gt; It seems like you're not performing the first step:
gt; Select ALL of the data in the range, not just the column you want sorted.
gt;
gt; Example
gt; If you have data in the range A1100 and you want to sort that range by
gt; Col_B in ascending order:
gt;
gt; Select A1100
gt; lt;datagt;lt;sortgt;
gt; Sort by: Column B
gt; Check: Ascending
gt; Click the [OK] button
gt;
gt; That would sort A1100 by Col_B, keeping the corresponding records
gt; associated with each Col_B item together with the item.
gt;
gt; Does that help? or am I missing something?
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP
gt;
gt;
gt; quot;BillyBobquot; wrote:
gt;
gt;gt; Thank you for your help Ron. When I go to Data - Sort - I do not seem to
gt;gt; have an option through which I can set the perameters. I am left with a
gt;gt; dialogue box which reads quot;lists sort byquot; and quot;then byquot; and quot;then byquot;. When I
gt;gt; go into the pull down menus all I am given an option of is which columns to
gt;gt; sort. A quot;blue boxquot; is evident on the data - but I don't know how to expand
gt;gt; this box to include the new data. When I try to expand the box it simplly
gt;gt; drops the old infomation on top of the new and overwrites it. So, the
gt;gt; question is how do I set source perameters - where do I need to look?
gt;gt;
gt;gt; Thanks
gt;gt; BillyBob
gt;gt;
gt;gt; quot;Ron Coderrequot; wrote:
gt;gt;
gt;gt;gt; BillBob:
gt;gt;gt;
gt;gt;gt; If you want to sort a multi-column range of cells:
gt;gt;gt;
gt;gt;gt; Select the entire range of cells
gt;gt;gt; lt;datagt;lt;sortgt;
gt;gt;gt; Set your sort parameters
gt;gt;gt; Click the [OK] button.
gt;gt;gt;
gt;gt;gt; If all of the relevant columns are not pre-selected, they will not sort with
gt;gt;gt; the column you want sorted and you'll have out-of-sync mess.
gt;gt;gt;
gt;gt;gt; Does that help?
gt;gt;gt; ***********
gt;gt;gt; Regards,
gt;gt;gt; Ron
gt;gt;gt;
gt;gt;gt; XL2002, WinXP
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; quot;BillyBobquot; wrote:
gt;gt;gt;
gt;gt;gt;gt; When attempting to sort data, newly entered data seems to stay the same while
gt;gt;gt;gt; the old data sorts itself. I have one whole column that is now mismatched.
gt;gt;gt;gt; I am a newbie to this program so I am sure I am doing not doing something
gt;gt;gt;gt; basic.

If you want to sort the entire sheet an easy way to select all cells is
to click the square in the upper left hand corner above the row number 1
and to the left of the column A.

gls858