When you sort, highlight (select) all columns of your data. Then you can
specify which column to sort on. The other columns that you selected will
get sorted as well.

"Loki" wrote:

I'm trying to catorgoize my DVD library. Can I link cells together so
that if I want to sort one row, say by author, it will also re-arrange
the cells/rows on each side. Not sure if that makes sense. I'd like to
be able to look for an author alphabetically, without loosing the name
of the DVD or catogory that's in the adjacent cells.next to the author