Microsoft Office Forums Moving cell content without moving borders & shading?

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-25-2013, 12:17 PM
unittwentyfive unittwentyfive is offline Moving cell content without moving borders & shading? Windows 7 32bit Moving cell content without moving borders & shading? Office 2010 32bit
Novice
Moving cell content without moving borders & shading?
 
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
  #2  
Old 10-25-2013, 12:56 PM
BobBridges's Avatar
BobBridges BobBridges is offline Moving cell content without moving borders & shading? Windows 7 64bit Moving cell content without moving borders & shading? Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 614
BobBridges will become famous soon enoughBobBridges will become famous soon enough
Default

Certainly a user can copy just the contents of a cell without copying other parts of it too (borders, fonts etc). But how to get them to do that—or how to prevent them from doing anything else—I don't know. You can "protect" a worksheet, and you can even protect certain cells or ranges on a worksheet. And that protection can be granular; you can allow users to sort rows but not add new rows, for instance. There seems to be the ability to allow a user to change the format without changing the contents. But I don't see an option under the Protection feature that would allow the reverse, to change the contents but not the formatting. I'm going to guess you can't get there from here.

I suppose there's a way to do it in VBA—there almost always is. But it would probably involve changing the formatting back whenever someone changed it, which might be overly complex, and more work than it's worth.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving cell content without moving borders & shading? Creating a Macro to change the shading of a cell Triscia Word VBA 3 01-30-2013 04:18 PM
Moving cell content without moving borders & shading? Moving sum dmrj78 Excel 3 10-29-2012 12:34 PM
Moving cell content without moving borders & shading? Page-crossing borders in a table with hidden between-cell borders tenpaiman Word 2 08-08-2012 07:20 PM
Moving cell content without moving borders & shading? Macro for moving one cell down from current position Johnny thunder Word VBA 3 04-07-2011 04:44 PM
Moving cell content without moving borders & shading? Moving formula range multiple cells when moving sum over one cell FraserKitchell Excel 4 02-26-2010 10:38 AM


All times are GMT -7. The time now is 08:27 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft