How to create an input cell.
When cell B1 is formatted as an input cell (by right-clicking the cell and clicking Format > Input Cell) and you lock the visualization (by right-clicking its top border and clicking Locked), you can change the value of the input cell to view results “on-the-fly.”
The following example shows a worksheet displaying the formula for an input cell.
This example shows the same worksheet displaying the result of the input cell formula.
In both examples, Row 1 shows the referrer currently being considered, Referrer A, while Row 2 shows the number of visitors who were referred from Referrer A.
After you format B1 and lock the visualization, you can change the value of the Referrer listed in B1 by simply typing the new value: