Edit multiple cells quickly in one single operation by using the Smart Edit function.
Simply highlight the cells you want to update and click smart edit.
There are 3 types of Smart Edit operation you can use:
Sum: Adds an inputted value to each of the selected cells
Ratio: Multiplies each selected cell by the inputted value
Absolute: Updates each selected cell to the inputted value (essentially a Bulk Update).
+44 (0)20 7078 4141