Perform Calculations Directly on Selected Cells in Excel Online with Calculation Tools

Working with numbers in Excel Online often requires creating formulas, adding helper columns, filling formulas across ranges, and then converting formula results back to values when you want to modify the original data.

For simple calculations, such as adding the same number to multiple cells, rounding decimals to integers, or applying a custom operation to an entire range, these extra steps can make a straightforward task unnecessarily time-consuming.

The Calculation Tools feature in ZKutools for Excel provides a faster and more convenient way to perform calculations directly on selected cells in Excel Online.

Instead of creating formulas one by one, you can select a range, choose an operation or function, preview the results, and apply the calculation to the selected cells in just a few clicks.

Where to Find Calculation Tools in Excel Online

After installing ZKutools for Excel and opening your workbook in Excel Online:

1. Select the cells you want to calculate.
2. Go to the ZKUTOOLS tab.
3. Click Convert > Calculation Tools.

The Calculation Tools pane will appear, providing different types of calculations and processing options.

You can perform basic arithmetic operations, apply built-in functions, or create a custom calculation according to your needs.

Before applying the calculation, you can check the results and make sure the selected operation produces the expected output in Preview pane.

Why Use Calculation Tools Instead of Excel Online’s Built-In Methods?

Excel Online already provides formulas and functions for performing calculations. However, when you want to apply the same operation to many existing values, the standard workflow usually requires several steps.

For example, suppose you want to add 10 to every value in a range.

Using Excel Online’s built-in methods, you may need to:

1. Create a helper column.
2. Enter a formula such as =A2+10.
3. Fill the formula down to the remaining cells.
4. Copy the calculated results.
5. Paste them back as values if you want to replace the original data.
6. Delete the helper column.

Calculation Tools simplifies this process.

Simply select the original cells, choose the calculation you need, and apply it directly.

The main advantages include:

• Perform calculations directly on selected cells.
• Process an entire range at once.
• Avoid creating temporary formulas and helper columns.
• Apply arithmetic operations and functions without writing formulas manually.
• Preview the calculation results before applying changes.
• Use custom calculations for more flexible data processing.
• Reduce repetitive steps when cleaning or transforming numerical data.

This makes Calculation Tools especially useful when you need to quickly modify existing numerical data in Excel Online.

Examples of Using Calculation Tools in Excel Online

Calculation Tools can be used for many practical data-processing tasks in Excel Online, from updating product prices to preparing payroll data and calculating selling prices.

The following three examples demonstrate how Multiplication, Apply a Function, and Custom can simplify common calculations and help you process existing data more efficiently.

Example 1: Increase All Product Prices by 20%

Suppose your company needs to update the prices of multiple products because of increased material and operating costs.

You have the following product price list:

The company decides to increase all product prices by 20%.

To increase a value by 20%, multiply the original price by 1.2.

How to Increase Prices by 20%

1. Select the cells containing the product prices.
2. Go to ZKUTOOLS > Convert > Calculation Tools.
3. In the Calculation Tools:
   1. Choose Multiplication.
   2. Enter 1.2.
   3. Preview the results. Then click OK or Apply.

The prices are updated.

All selected prices are increased by 20% at once without creating formulas or helper columns.

This is especially useful for bulk price adjustments, annual price updates, cost increases, budget revisions, and other tasks where the same percentage change needs to be applied to multiple values.