Clear data spreading method
The Clear method clears values from cells in a view. You can apply this method to either leaf cells or consolidated cells. When you apply the Clear method to a consolidated cell, all leaves of the consolidation get set to zero.
If you initiate the Clear method from the selected cell and extend the spreading operation downward, the leaves of all consolidations below the point of insertion are cleared.
Data entry shortcut code
To clear values to the left and down, type this code:
c<|