I can't make my spreadsheet work

[ritaxis]

When I try to sort my spreadsheet (which is Quattro Pro, but it works as far as I can tell exactly like Excel), it will only sort a column at a time, which means of course that every gets screwed up. because I'm trying to treat the columns as fields, and the rows as single entries. How do I lock the rows straight across so that, for example, if I sort the items in column A alphabetically, the material in the other columns stays aligned with the proper entry in column A? I would have thought this behavior would be the default.

My submission tracker thingy doesn't work properly if I can't group all the entries for one title together -- as it gets longer it becomes harder to know whether I've seen all the places a story's been.

Of course this would be much simpler if the damned stories sold.