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.

John

Just make sure that all columns are selected before going to DataSort

Do not rely on Excel to guess the range.

Do not use the A-Z, Z-A buttons.

Always go through the "sort by" dialog.

No way to ensure this unless you give each dept. its own worksheet with a sort
button assigned to a macro which pre-selects the columns.


Gord Dibben MS Excel MVP

On Thu, 16 Mar 2006 14:20:29 -0800, John Harris
wrote:

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 can’t
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.