Forum Discussion

Aaron_Petrowske's avatar
Aaron_Petrowske
Copper Contributor
May 03, 2021

Pasting of Formulas and Formatting

Hello.  I have a shared spreadsheet with table in it.  It includes data validation and one formula.  Other individuals either directly enter information or copy and paste from other sources.  The direct entries are no problem, as the drop downs and data validation work well.  When information is pasted from an outside sheet though, it is very easy to paste the external formulas and formatting, which can "mess up" the table and cause the need to "repair" it, which takes time.  

 

I've requested they paste values only, but this scenario is still happening.  Is there a way to control pasting and only allow values to be pasted?

 

Thanks, 

Aaron

Resources