software

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.

John

Just make sure that all columns are selected before going to Datagt;Sort

Do not rely on Excel to guess the range.

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

Always go through the quot;sort byquot; 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
gt; wrote:

gt;Freguently, I need to provide multiple departments with the same table of
gt;data. The various departments have different priorities so they like to
gt;resort the data based on various columns.
gt;
gt;I want to lock the rows of a spreadsheet so that a not-so-smart person can’t
gt;accidentally highlight one column and sort the data thus screwing up the
gt;chart because column B no longer matches up correctly with column C (or
gt;whatever); I want to ensure that all of the data in the rows stay together
gt;while allowing people to still sort by different fields, as you can in MS
gt;Access. I know how to lock an entire spreadsheet or cells, but not how to
gt;just lock the rows so that they data in that row stays together while one
gt;column is sorted. I am not sure it is possible.
gt;
gt;Thanks in advance.