Protect cells in Excel so that users can only paste in text

  • Thread starter Thread starter Mike Mayer
  • Start date Start date
M

Mike Mayer

Is there any way to protect cells in Excel so that users
can only paste in text and not any formatting?
 
Mike said:
Is there any way to protect cells in Excel so that users
can only paste in text and not any formatting?

Not directly
The best you can do is disable or remove the ability to paste other
than Paste / Values.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Back
Top