prevent sorting from moving rows/colums out of order

[David]

A shared excel sheet gets a daily addition by each of the shared users.
After the information is added, the sheet is sorted. Can the excel sheet be
locked so that if someone sorts the sheet and accidentally does not include a
column, it will not sort the sheet until all columns are included in the sort.

Example: Columns A-E and Rows 1-10 are used, but when sorted, user did not
include all Columns and only sorted with B-E, now Column A does not line up
with correct rows after sort.

 

[ShaneDevenshire]

Hi,

Without programming - no. However, this is a training issue, you need to
teach the users how to sort properly.

You might minimize the problem if your data is setup properly - one row of
titles, no superfulous data adjactent to the data, all data contiguous. Then
have the user put their cursor in the column they want to sort on and click
the Ascending or Descending Sort buttons.
Or have them select a single cell in the data range and choose Data, Sort.