Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am using Excel 2007 and finding that sometimes when I sort a list of values
smallest to largest it puts a value out of order in the first cell of the column of sorted values. I have even cut and pasted that record back in its right place, then perform a sort again and it goes back to the first cell. This happens whether the cell format is general, text or number. It happens when I sort from largest to smallest - the out of order value just goes to the bottom of the list. Here is part of the list I am sorting and what it looks like when I sort Smallest to Largest (A-Z): 39101613 26101101 26101102 26101103 26101105 26101106 Has anyone experienced this before? What can I do to remedy? Thank you, Jen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to keep column headings from being sorted with data? | New Users to Excel | |||
How do I stop column headers from being sorted in a row? | Excel Discussion (Misc queries) | |||
my column is sorted in two sections. How do I sort entire column? | Excel Discussion (Misc queries) | |||
my column is sorted in two sections. How do I sort entire column? | Excel Discussion (Misc queries) | |||
How attach data in a row so it can be sorted by the date column? | Excel Discussion (Misc queries) |