<aside> 💡 Note: Available only in Professional and Premium plans.

</aside>

Edit Cell allows you to edit the value in a single cell. This section covers:

• How to edit cell
• Cell Editing types

How to Edit cell

1. Select a cell, and then go to INSERT > Edit Cell. Or double-click the cell to edit it.

   

   Edit the selected cell

Related Links

Invert

Formula Syntax

1. A formula bar appears at the top with the cell path which can be used to edit the cell value. Users can also add data directly into the cell.

   

   Edit data in the selected cell

2. Click on the tick mark or press Enter Key to save the value

3. The pen sign on the cell shows that the data cell value is edited.

   

4. Click on the reset icon to return the cell to the original value.

   

   Reset to the original value

5. Click on the close icon to close the formula bar. If you close the formula bar before clicking on the tick mark icon, the updated value is not saved.

Cell editing types

1. Apply an adjustment to the value (Add, subtract, divide, multiply or use other functions)

   

   Increment the value

   

   Multiple of the original value

   

   Apply one of the Inforiver functions on the original value

2. Change the entire value

   

3. Reference another cell value and apply some calculations

   

4. Show sum of the children as the total/subtotal by choosing Sum of Children from the drop down on clicking the Quick Actions icon (Applicable only for totals and subtotals).

   

The subtotal is shown as sum of the children

<aside> 💡 Note: The changes made to the cell will affect the subtotal/total values.

</aside>