# 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. {% hint style="info" %} Another way to enable the formula bar is by selecting a cell and clicking the **Edit Cell** button in the Insert ribbon. {% endhint %} 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).

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.

{% hint style="info" %} * 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. {% endhint %} ### 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.

2.3. We can reference multiple cells in a formula. Click the

button or press Enter to apply the formula.

### 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.