Video Training for Options: Manage Paste Values Only
Transcript and Screenshots for Options: Manage Paste Values Only
In the Options tab, the link towards the feature Manage Paste Values Only is available under the section Behaviour Management.
When you click on that link, you reach the section where you can enable, or disable, the feature.
This feature is very helpful to keep proper formatting, especially proper conditional formatting, when cells are copied and pasted in the workbook.
When this feature is enabled, each time you paste cells in this risk management workbook, only the values of the pasted cells are kept, and not their format and conditional formatting.
This means that the cells where the values are pasted keep their own format and conditional formatting.
It is recommended to enable this feature for regular use of this risk workbook, which is when you are not programming.
When this feature is disabled, each time you paste cells in this risk management workbook, the values, the format and the conditional formatting of those cells are kept.
This means that the cells where the values are pasted will loose their own format and conditional formatting.
It is recommended to disable this feature when you are programming in this risk workbook, otherwise, when copying and pasting cells with a formula, you will loose the formula which will be replaced by its outcome or value.
To enable or disable this feature, simply click on the drop-down list and select the item you want.
Additional Help & Training
Download the Risk Template in Excel