Just be sure to select the entire range of values before sorting. That means
columns A through E

"bandre" wrote:

Goal: To have the option of an alphabetical list of books by titles or an
alphabetical list of books by authors.
Problem: Column A lists the book titles. Column B lists the authors. These
must obviously stay together. When column A is alphabetized, how do I get
column B to follow column A and visa versa? (column C is Checked-Out, column
d is Checked-In, column E is church member name) Therefore, the ultimate
goal is to be able to change the worksheet to glance and see who has a book
out (by bringing all the checked-out to the top, or any alpahbetized list
needed.

Microsoft Excel 2000