Yes, I have a table in XL2007 for example

Sales
Salesman January February March April May
Sam 528 388 484 1498 921
Pete 401 1492 1221 1076 1091
John 1107 1222 945 1056 909
James 1104 1120 403 417 566
Holly 559 797 1480 368 1041
Anne 591 551 1285 1279 1381
TOTAL 4290 5570 5818 5694 5909

If I try to sort the salesmen alphabetically it does it no problem but as
soon as I convert it to a table using Ctrl T the sort will then sort the
whole of the first column not just what I have selected.

I hope that this is clearer.

Caz

"Dave Peterson" wrote:

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