Editing cells

Premium Table allows you to edit the contents of a cell and apply calculations. These are visual-level updates and will not impact the source dataset.

1. Overwriting values

To overwrite an existing value, simply double-click on the cell and enter the new value. You can enter scaled values (250m, 5.6b, etc.) or reference other cell values.

Another way to enable the formula bar is by selecting a cell and clicking the Edit Cell button in the Insert ribbon.

Double-click on a cell as shown in the image. A formula bar is enabled below the toolbar. Type in a value and click Enter. Note that Premium Table allows entry of scaled values (e.g., 45.3m instead of 45,300,000).

Overwriting cell values

The value gets updated and the manual update can be identified by the pencil icon in the cell. The total row is also updated to include the value entered.

Edited cells can be identified from the pencil icon

You can even reference other cells and apply formulas to them using the cell editor. You can define simple mathematical operations such as A +/- B, etc.

Referencing cell values in formulas
  • You can also edit cells using the 'Edit cell' icon in the toolbar. You can access it in the Insert tab > Cell section.

  • Premium Table allows you to edit AC, PY, PL, FC, and OM measures. You can edit dates and text measures as well.

2. Apply formulas

You can use the wide range of formulas and functions available in Premium Table while editing a cell. In the below example, we are using the 'Average' function. As you start typing, you can see the functions that match the entered text as a list. Click on 'Average'.

2.1. Click on the arrow icon to see more information, such as the arguments and examples.

View syntax and examples for supported formulas

2.2. You can click on any cell, and it gets automatically populated as shown below.

Referencing a cell in a formula

2.3. We can reference multiple cells in a formula. Click the button or press Enter to apply the formula.

Referencing multiple cells

3. Updating multiple cells

You can also override the data in multiple cells with the same value, for instance, set a fixed budget. Select the cells and update the value in any cell; the updated value will be cascaded to all the selected cells.

4. Renaming Row Categories

You can also rename row categories by double-clicking on them.

Renaming row categories

Last updated