Ensure data is entered inside the Tale

The most common reason why users find that the output of the template does not reflect the inputs is that the input data is not entered inside the tables correctly. To know if your data is inside the Table, click on the cell and see if Table Tools ribbon appears.

Table Tools - Design Ribbon
Table Tools – Design Ribbon


If it does, your data is inside the table. If not, it is not inside the Table and hence will not be reflected in any dependent calculations.

If you are inside the table and want to know the boundaries of the table, press Ctrl+A. Excel will select all the data cells inside the table and thus show us the boundaries.

Finding Boundary of Table
Finding Boundary of Table