Sorting while preserving relationships in rows
Posted by Roger on May 22, 2001 6:44 PM
The data I have in each row always belongs together. Occasionally I accidentally sort using the column number (A, B, C....), (and the sort button on the toolbar) when I meant to use the column heading. I still want to be able to freely edit any individual cells. Is there a way to "group" the data in each row so it cannot be split up by a sort.
Posted by Connie on May 23, 2001 6:49 AM
Roger,
You should be able to maintain the relationship between the data in your rows as long as you are selecting the entire worksheet when you do your sort. For example, if your sheet looks like this starting at A1,
A B C
Peaches $1.29 Fort Worth
Apples $2.25 Dallas
Grapes $1.05 Chicago
you would select all cells, then go to Data>Sort
and choose whichever column you want to sort by. Be sure to check if you have column headings. If you want to sort by fruit, choose A. Your results will maintain the same row relationship because you've selected the whole sheet, so your table will look like:
Apples $2.25 Dallas
Grapes $1.05 Chicago
Peaches $1.29 Ft. Worth
If this answer doesn't get at what you were asking, please post again so maybe someone else can help.
