one of our managers does not want to have to protect a work sheet (some need
to be able to add information), but does want to keep certain adjoining cells
on each row together. For instance

C - D - E .... should always be kept together.

Current situation: someone deletes a cell from column D, and chooses 'shift
cells up' for the remaining cell, and then nothing below this one works
anymore.

Is there an easy way to accomplish this (besides eliminating idiots from the
department)? I haven't found it so far.