How do I lock rows so I can sort using any column?

[Robin]

I want to be able to sort a spreadsheet according to any column heading,
i.e., Date, Name, Type of Case, etc. However, if I pick a column, it sorts
only that column (A-Z) and doesn't move the rest of the data. Thus, all the
data gets mixed up and doesn't pertain to the column next to it. How do I
sort the data using any column I want, as opposed to selecting the entire
sheet and sorting according to the first column only?

 

[Douglas J. Steele]

I'd suggest asking this in a newsgroup related to Excel.

This newsgroup is for questions about Access, the database product that's
part of Office Professional.