Forum Discussion

ginalk2019

Copper Contributor

Jun 07, 2019

protect borders

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 l...

excel

SergeiBaklan

Diamond Contributor

Jun 08, 2019

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.

JustinTanChKg

Copper Contributor

Jun 09, 2019

Hi SergeiBaklan,

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