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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 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
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies