keep cells together
 

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.

keep cells together
 

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" wrote:

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.

keep cells together
 

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



"michelle" wrote:

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" wrote:

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.