Changing Characteristic Values 
You can change some or all of the values that you have already specified for characteristics in a matrix by doing the following:
Changing values manually in a matrix
Changing the existing values by typing over them in the worksheet directly
Changing values by means of proposal lists
Procedure
You can change values by means of proposal lists by doing one of the following:
Changing characteristic values from a selection list
Place the cursor on the cell you want to change.
For sets and/or single values, select a value from the dropdown listbox.
You cannot change hierarchies by using the listbox because there is no dropdown for cells with hierarchies.
When the value listbox appears, click the required value, for example, the name of a specific consolidation unit, and then click OK.
Changing characteristic values by overwriting existing values
Place the cursor on the cell in which the characteristic you want to change is located.
On the Data Matrix tab, select the relevant characteristic type and the characteristic.
When prompted, confirm that you want to overwrite the existing value.
A dialog box appears with a list of values for the characteristic.
Select a value, check that the display format is correct, and then click OK.