I’m currently using the latest version of OpenOffice.org Calc, but I believe this should be generalizable to Excel. What I want to do is lock a row of cells together, so that when I sort one column, it won’t just move the elements in one column around and leave all the other associated information in the other columns untouched. I’ve tried looking under the help topics, but nothing really seems to be what I want. Any help?
Select all of the cells with data in them. Go to Data, Sort to select which columns to sort by.
Can’t comment on Open Office, but for Excel:
It is best to have your data arranged as a proper “list”… this is a rectangle with no blank rows or columns (the occasionally blank cell is ok). And the first row is a header, and it is formatted to stand out. Excel sees all this and says to itself “aha, a list! I won’t mix these rows up when I sort them”.
If you select one cell in the list and click on the sort, Excel doesn’t even ask you what you’re intentions are, it just sorts the list based upon the column the selected cell is in. If you select more than one cell in the list, but not all the columns, Excel will pop up a dialog box asking you if you want to include the adjacent columns.
If you have data not in a list, it will probably just sort the selected cells.