| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
| Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Linear Mode
