Last column in Excel does not sort
 

On several excel spreadsheets, when I sort them, sometimes, the last
column(s) don't sort with the rest of the worksheet, so as you can
imagine, the data is not much good and all has to be re-entered if it
is available. Do you have any ideas?? Any help is appreciated..

Last column in Excel does not sort
 

forbes

First of all, when this happens, just hit the "Undo" button to go back to where
you were.

Second..........never let Excel guess what your data range is for a sort.

Pre-select all columns you want sorted together before running the sort.


Gord Dibben MS Excel MVP

On 3 Feb 2006 10:21:56 -0800, "forbes" wrote:

On several excel spreadsheets, when I sort them, sometimes, the last
column(s) don't sort with the rest of the worksheet, so as you can
imagine, the data is not much good and all has to be re-entered if it
is available. Do you have any ideas?? Any help is appreciated..