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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robin - 28 May 2005 14:25 GMT

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?

Reply to this Message

Douglas J. Steele - 28 May 2005 14:56 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>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
[quoted text clipped - 4 lines]
> sort the data using any column I want, as opposed to selecting the entire
> sheet and sorting according to the first column only?

Reply to this Message