Forum Discussion
dmaroschek
Aug 23, 2022Copper Contributor
Lock formatting
I run a warehouse that people request parts from and have decided to create an excel sheet for them to use to send the requests on. Most of the time they just copy and paste from another document whi...
Andytcc
Aug 23, 2022Copper Contributor
Sorry i didn't read your question right. i thought you wanted to protect your sheet.
when you copy and paste you can select what you want to paste by clicking right hand mouse and select paste special. there you can select what you want pasted, or you can select "Keep Source Formatting" this will paste everything except format. or hold down "ctrl" button and press "K" this will paste as "keep source Formatting" hope this works.
when you copy and paste you can select what you want to paste by clicking right hand mouse and select paste special. there you can select what you want pasted, or you can select "Keep Source Formatting" this will paste everything except format. or hold down "ctrl" button and press "K" this will paste as "keep source Formatting" hope this works.
dmaroschek
Aug 23, 2022Copper Contributor
Andytcc i am looking specifically for something i can do on my end that stops the user from being able to make format changes. I'm dealing with 30+ shops in 19 states so teaching them how to paste without format changes isn't practical.