Home

Lock/protect cells to only except pasted values

%3CLINGO-SUB%20id%3D%22lingo-sub-457451%22%20slang%3D%22en-US%22%3ELock%2Fprotect%20cells%20to%20only%20except%20pasted%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-457451%22%20slang%3D%22en-US%22%3EHi%20All%2C%20I%20was%20hoping%20someone%20could%20explain%20how%20I%20could%20set%20up%20a%20range%20of%20cells%20in%20a%20spreadsheet%20that%20do%20not%20allow%20any%20values%20that%20are%20typed%20into%20a%20cell%2C%20only%20those%20that%20are%20copied%20and%20pasted%20from%20another%20source.%3CBR%20%2F%3E%3CBR%20%2F%3EIt's%20for%20work%20and%20I%20need%20to%20have%20something%20in%20place%20for%20audit%20purposes%20to%20demonstrate%20that%20the%20data%20represented%20in%20the%20range%20is%20an%20exact%20copy%20of%20the%20source%20data%20and%20it's%20not%20possible%20for%20someone%20to%20manually%20type%20over%20it%20by%20mistake.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%2C%3CBR%20%2F%3EJames%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-457451%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Gigolojim
Occasional Visitor
Hi All, I was hoping someone could explain how I could set up a range of cells in a spreadsheet that do not allow any values that are typed into a cell, only those that are copied and pasted from another source.

It's for work and I need to have something in place for audit purposes to demonstrate that the data represented in the range is an exact copy of the source data and it's not possible for someone to manually type over it by mistake.

Thanks,
James
Related Conversations