To specify whether the current cell is a control cell
1.
In the target cell spreadsheet in Edit mode, click in the Control Cell column for the cell you are editing.
The cell becomes editable, with a drop-down list.
2.
Select Yes or No from the drop-down list to indicate whether the current cell is a control cell.
3.
Click Save or Save and Return to save your changes.
*
If you assign a control cell (for example, Cell A) as the control for one or more target cells, then subsequently change the Cell A to a target cell, Cell A is removed as a control from any target cells that previously used it as a control.
Copyright IBM Corporation 2015. All Rights Reserved.