Last column in Excel does not sort

[forbes]

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..

 

[Gord Dibben]

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