Home

protect borders

%3CLINGO-SUB%20id%3D%22lingo-sub-677825%22%20slang%3D%22en-US%22%3Eprotect%20borders%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-677825%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20is%20there%20a%20way%20to%20protect%20borders%20on%20excel%3F%26nbsp%3B%20We%20have%20forms%20that%20have%20different%20thicknesses%20in%20the%20borders%20and%20when%20people%20copy%20and%20paste%2C%20the%20thickness%20can%20change%2C%20which%20makes%20the%20whole%20form%20look%20goofy.%26nbsp%3B%20Is%20there%20a%20way%20to%20let%20them%20copy%20and%20paste%20where%20the%20border%20doesn't%20change%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-677825%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-678679%22%20slang%3D%22en-US%22%3ERe%3A%20protect%20borders%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678679%22%20slang%3D%22en-US%22%3EIf%20they%20do%20Paste%20Values%20the%20borders%20won't%20change%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-678682%22%20slang%3D%22en-US%22%3ERe%3A%20protect%20borders%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678682%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356595%22%20target%3D%22_blank%22%3E%40ginalk2019%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI%20don't%20believe%20there's%20a%20way%20to%20specifically%20protect%20borders%20on%20Excel.%20But%20if%20anyone%20knows%20of%20this%2C%20please%20let%20us%20know!%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20workaround%20for%20this%2C%20as%20mentioned%20by%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%2C%26nbsp%3Bis%20to%20copy%20your%20source%20data%20and%20then%20paste%20special%20them%20into%20the%20form.%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20do%20this%20via%20several%20methods.%3CBR%20%2F%3E%3CBR%20%2F%3EAfter%20copying%20your%20data%2C%20you%20can%20highlight%20the%20data%20region%20which%20you%20wish%20to%20dump%20your%20data%20on%2C%20and%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B1)%20Right-click%20with%20the%20mouse%2C%20and%20select%20paste%20special%20(values%20only)%2C%20or%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B2)%20Use%20the%20keyboard%20shortcut%2C%20Alt%20%2B%20E%20%2B%20S%20%2B%20V%20%2BEnter%3CBR%20%2F%3E%3CBR%20%2F%3EBoth%20of%20these%20should%20work%20for%20the%20problem%20you're%20facing%20right%20now!%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%3CBR%20%2F%3EJustin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-678849%22%20slang%3D%22en-US%22%3ERe%3A%20protect%20borders%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678849%22%20slang%3D%22en-US%22%3EAs%20previously%20mentioned%20I%20don't%20think%20there%20is%20any%20way%20of%20protecting%20cell%20borders.%20The%20issue%20with%20asking%20people%20to%20use%20paste%20special%20is%20they%20always%20forget%2C%20so%20that%20doesn't%20really%20work%20either.%20What%20about%20a%20macro%20that%20runs%20on%20closing%20the%20workbook%20that%20will%20reinstate%20the%20borders%3F%20I%20assume%20that%20the%20extent%20of%20the%20borders%20doesn't%20change%20much%20within%20the%20form%2C%20just%20the%20information.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-678904%22%20slang%3D%22en-US%22%3ERe%3A%20protect%20borders%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678904%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356840%22%20target%3D%22_blank%22%3E%40JustinTanChKg%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJustin%2C%20few%20more%3C%2FP%3E%0A%3CP%3EIf%20by%20mouse%2C%3C%2FP%3E%0A%3CP%3E-Add%20to%20Quick%20Access%20Toolbar%20icons%20Copy%20and%20Paste%20Values%20(Copy%20is%20only%20not%20to%20jump%20from%20ribbon%20to%20QAT)%20and%20train%20people%20to%20use%20them%20instead%20of%20ribbon%20Copy%2FPaste.%3C%2FP%3E%0A%3CP%3E-%20right%20click%20selected%20cell%2Frange%20border%2C%20drag%20it%20to%20the%20destination%20place%20and%20Copy%20Here%20as%20Values%20Only%20from%20appeared%2C%20after%20you%20release%20right%20button%2C%20menu.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20by%20keyboard%2C%20Ctrl%2BC%20%3D%26gt%3B%20Ctrl%2BV%2C%20Ctrl%2C%20Down%2C%20Down%2C%20Enter.%3C%2FP%3E%0A%3CP%3EAnd%20I%20still%20prefer%20Ctrl%2BIns%2FShift%2BIns%20instead%20of%20Ctrl%2BC%2FCtrl%2BV.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-678943%22%20slang%3D%22en-US%22%3ERe%3A%20protect%20borders%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678943%22%20slang%3D%22en-US%22%3EMy%202%20favourites%20are%20%3CBR%20%2F%3E%3CBR%20%2F%3ECtrl%20c%2C%20Ctrl%20v%20followed%20by%20Ctrl%20then%20v%3CBR%20%2F%3E%3CBR%20%2F%3EOr%3CBR%20%2F%3E%3CBR%20%2F%3ECtrl%20c%2C%20then%20right%20click%20button%20on%20keyboard%20followed%20by%20v%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-678944%22%20slang%3D%22en-US%22%3ERe%3A%20protect%20borders%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678944%22%20slang%3D%22en-US%22%3EIf%20you%20know%20VBA%20then%20you%20can%20refer%20to%20the%20code%20in%20my%20response%20here%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FA-way-to-totally-and-reliably-block-PASTE-operations-in-Excel%2Ftd-p%2F488124%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FA-way-to-totally-and-reliably-block-PASTE-operations-in-Excel%2Ftd-p%2F488124%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-678958%22%20slang%3D%22en-US%22%3ERe%3A%20protect%20borders%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678958%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWyn%2C%20where%20possible%20I%20prefer%20not%20to%20use%20alphabet%20buttons%20with%20shortcuts%20-%20have%20to%20look%20on%20keyboard%20to%20press%20right%20button.%20With%20other%20keys%20I'm%20practically%20don't%20change%20the%20focus%20from%20the%20screen%20on%20keyboard%20and%20back.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20why%20my%20variant%20of%20your%20first%20combination%20is%20Shift%2BIns%20instead%20of%20Ctrl%2BV%20and%20double%20Down%20instead%20of%20v.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-679541%22%20slang%3D%22en-US%22%3ERe%3A%20protect%20borders%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679541%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20for%20expanding%20on%20these!%3CBR%20%2F%3E%3CBR%20%2F%3EYes%2C%20the%20QAT%20is%20actually%20a%20great%20method%20as%20you've%20mentioned.%20I%20completely%20forgot%20about%20this%20nifty%20little%20tool!%3CBR%20%2F%3E%3CBR%20%2F%3ERegarding%20keyboard%20shortcuts%2C%20somehow%20Alt%20%2B%20E%20%2B%20S%20%2BV%20%2B%20Enter%20feels%20a%20lot%20more%20intuitive%20for%20me.%20Maybe%20it's%20because%20E%20and%20S%20are%20right%20next%20to%20each%20other%2C%20and%20V%20isn't%20that%20far%20off%20either.%20What's%20more%2C%20all%203%20letters%20reside%20in%20the%20left%20side%20of%20the%20QWERTY%20keyboard%20configuration!%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%3CBR%20%2F%3EJustin%3C%2FP%3E%3C%2FLINGO-BODY%3E
ginalk2019
Occasional Visitor

Hello, is there a way to protect borders on excel?  We have forms that have different thicknesses in the borders and when people copy and paste, the thickness can change, which makes the whole form look goofy.  Is there a way to let them copy and paste where the border doesn't change?

Thanks

8 Replies
If they do Paste Values the borders won't change

Hi @ginalk2019


I don't believe there's a way to specifically protect borders on Excel. But if anyone knows of this, please let us know!

The workaround for this, as mentioned by @Wyn Hopkins, is to copy your source data and then paste special them into the form.

You can do this via several methods.

After copying your data, you can highlight the data region which you wish to dump your data on, and:

     1) Right-click with the mouse, and select paste special (values only), or;

     2) Use the keyboard shortcut, Alt + E + S + V +Enter

Both of these should work for the problem you're facing right now!


Best,
Justin

Highlighted
As previously mentioned I don't think there is any way of protecting cell borders. The issue with asking people to use paste special is they always forget, so that doesn't really work either. What about a macro that runs on closing the workbook that will reinstate the borders? I assume that the extent of the borders doesn't change much within the form, just the information.

@JustinTanChKg 

 

Justin, few more

If by mouse,

-Add to Quick Access Toolbar icons Copy and Paste Values (Copy is only not to jump from ribbon to QAT) and train people to use them instead of ribbon Copy/Paste.

- right click selected cell/range border, drag it to the destination place and Copy Here as Values Only from appeared, after you release right button, menu.

 

If by keyboard, Ctrl+C => Ctrl+V, Ctrl, Down, Down, Enter.

And I still prefer Ctrl+Ins/Shift+Ins instead of Ctrl+C/Ctrl+V.

My 2 favourites are

Ctrl c, Ctrl v followed by Ctrl then v

Or

Ctrl c, then right click button on keyboard followed by v

@Wyn Hopkins 

 

Wyn, where possible I prefer not to use alphabet buttons with shortcuts - have to look on keyboard to press right button. With other keys I'm practically don't change the focus from the screen on keyboard and back.

 

That's why my variant of your first combination is Shift+Ins instead of Ctrl+V and double Down instead of v.

Hi @Sergei Baklan,


Thanks for expanding on these!

Yes, the QAT is actually a great method as you've mentioned. I completely forgot about this nifty little tool!

Regarding keyboard shortcuts, somehow Alt + E + S +V + Enter feels a lot more intuitive for me. Maybe it's because E and S are right next to each other, and V isn't that far off either. What's more, all 3 letters reside in the left side of the QWERTY keyboard configuration!


Best,
Justin

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies