Most spreadsheets have literal values and formulas that evaluate those literal values. Sometimes, you have to delete all the literal values, or input cells. Ensuring that you (or your users) don’t accidentally delete formulas at the same time is a serious consideration. You could protect the sheet or provide a macro that clears the input cells before distributing a workbook, but you don’t always have that much control over the spreadsheets users create themselves.
There’s also a manual technique for clearing input cells. It’s dependable and will take just a minute to train most users as follows:
|
2003 |
2007/2010 |
|
|
It’s that simple! Input values are gone, and formulas remainl intact. It’s a great way to help users protect their own spreadsheets.
