Freguently, I need to provide multiple departments with the same table of
data. The various departments have different priorities so they like to
resort the data based on various columns.

I want to lock the rows of a spreadsheet so that a not-so-smart person cant
accidentally highlight one column and sort the data thus screwing up the
chart because column B no longer matches up correctly with column C (or
whatever); I want to ensure that all of the data in the rows stay together
while allowing people to still sort by different fields, as you can in MS
Access. I know how to lock an entire spreadsheet or cells, but not how to
just lock the rows so that they data in that row stays together while one
column is sorted. I am not sure it is possible.

Thanks in advance.