Do you really mean a Table (in xl2007)?

If you just meant a range, are you selecting the range to sort (and avoiding
that total cell)?



Cazzy123 wrote:

Hi,

If I try to sort selected data in a table it automatically sorts the whole
column. For example if i try to sort the salesmen in A-Z the total column
beneath it also sorts even though I have not highlighted it.

Is it because I have not left a row inbetween or should it be able to sort
selected rows only?

Many Thanks

--

Dave Peterson