quote: However I'm still not quite getting it from your description. If I only select one column (the one I'm interested in, such as number of Allied units, then that is the only column that gets sorted. Really the whole table has to be sorted equally but based of a selected column, other wise no sense to the answers. I've tried selecting the whole table, but then don't see how to pick the particular column for the primary sort? (MS on-line help is next to useless in my opinion.
I do have MS Office on this computer (though I use Quatro Pro).
At least I should be able to print out the table as is, and have something to work with.
(Sorry for the duplicate post, I hit the wrong key on the first one, and for some reason the "edit" button is working for me!)
Select the whole table except for the column headers before you sort, otherwise the headers will be sorted too. But make sure that the ROW headers are selected. And NEVER sort by selecting a single column, because you will lose all information about what each row of the sorted column corresponds to.If you do it by mistake, you can always try the "undo" command.