I have created an Excel data base with multiple columns (ID No., Name, Phone,
Address) that need to be sorted using different columns (Name, ID No. or ID
No., Name). The problem is that Im not the only one to use this data base
and some people do not select all of the columns before doing a sort. When
thats done the Name and IDs are resorted but the rest of the information
stays where it was.

Can I lock the rows so that the data in each row is €œlocked€� to the rest of
the data in that row?

Thanks in advance,

Lee