View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David David is offline
external usenet poster
 
Posts: 1,560
Default prevent sorting from moving rows/colums out of order

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.