The Input bar

Assumptions: whatever is changeable in the spreadsheet by the customers is called an Input.

In the sheet on the top right-hand side, you will notice an Input icon in Blue color. When you click the Input icon, you will see a rectangular bar in Blue. This bar is called the Input bar. You will also notice that the values in the columns that are changeable are in blue.

In the Lookup sheet, the Input bar has two buttons: the Toggle button for the Scenarios and the Fill Down button.

In the Time based sheet, the Input bar has three buttons: two toggle buttons, first for the Scenarios and second for Show All, and the Fill Right button.

A toggle button allows the customer to change a setting between two states.

1. Either All Scenarios or This Scenario

2. Either Show All or Show Inputs

A Fill Down button allows the customer to fill the values across the current column vertically. 

A Fill Right button allows the customer to fill the values across the current row horizontally.