keep cells together

[JusMe]

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.

 

[michelle]

select all cells, right click then 'unlock'.

next select columns C, D & E right click then 'lock cells'.

protect sheet (only columns C, D, E will be locked for editing)

hope that helps,
michelle

 

[JusMe]

yup, that solves this issue. Thanx for the thought.