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.

Comments

[hrj.livejournal.com]

If it were Excel, I'd be certain that I have the answer for you -- not quite as certain whether it applies to Quattro.

If this were happening in Excel, it would be because you had selected a subset of columns and then told it to sort -- and it would obediently sort only the selected block and leave the rest alone. To keep the rows intact when sorting, you want to select your affected block as entire rows. In Excel, this would involve dragging your cursor along the "row marker" column at the far left of the table so that the highlighted portion stretches infinitely in the horizontal direction. If you're sorting the entire table, you can just click on the upper lefthand corner.

Does that sound like it works for your program?

[ritaxis.livejournal.com]

I don't know why it didn't work before, but now it does, thanks.