Hello everyone,

Does anybody know of a way to lock an Excel document's layout so that when someone copy/pastes or click/drags cells around, they don't move the borders and shading with the cell's content?



I have a sort of weekly-planner thing that a bunch of people have access to. They go in and move around events and such to coordinate the use of our meeting/event spaces, but a lot of them aren't really "computer people" so they end up dragging the sheet into a mess of mismatched borders and colors.

I just want to be able to set the framework for the layout of the sheet, and have it so that if anybody moves something, it's just the content that moves and the cell-structure stays the same.

Thanks for any input on this.

~Joe