View Single Post
 
Old 10-25-2013, 12:17 PM
unittwentyfive unittwentyfive is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Oct 2013
Location: At sea!
Posts: 10
unittwentyfive is on a distinguished road
Default Moving cell content without moving borders & shading?

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
Reply With Quote