If you have for example in A1:A5 the data: a, z, g, b, c, and you select
just A1:A3 then the sort should leave the last two items untouched
However, if you have an actual Excel Table (made in Excel 2007 with the
command Insert | Table), or an Excel List in 2003, then sorting will affect
the entire table (this being one of the purposes of making a Table)
I wish MS had a better word than Table - it is ambiguous That is why I use a
capital T or speak of Excel Table.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Cazzy123" wrote in message
...
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