yes, tried highlighting myself and then sorting it, but still... maybe one or
two move. I can't seem to think how I could be doing it wrong? Is it just
not possible to move a whole row by one criteria?



"Spiky" wrote:

On Jun 6, 10:35 am, newbie wrote:
Thanks for your help, but I have tried that. When I select all and then use
the sort command, only a two cells out of 10 move and the ones that do move
don't stay with the rest of their row, if that makes sense. Any other ideas?

"Spiky" wrote:
On Jun 6, 10:01 am, newbie wrote:
I need to sort a total column that was created from adding up other cells.
Where I run into a problem is that I need the whole row to go with it when it
does sort. Each row has a name, three column boxes of data, then a total
that was created by using a sum function. I want to sort by the total but
keep everything in tact. I know it seems quite elementary, but I can't seem
to find a way to make this work. Any help? Thanks.

Select the whole area that you need to sort, including row and column
titles, then do the Sort command.

Did you manually select the area or just hit Select All? It will only
sort the highlighted area, so you have to force it to do what you want
by choosing that area yourself.