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.

Example 2: Convert Negative Expense Amounts to Positive Values for Reporting

Suppose you export transaction data from an accounting system to Excel Online. In the exported data, expenses are recorded as negative values because they represent cash outflows.

However, when preparing an expense report, you only need to display the actual amount of each expense as a positive value.

The original data is:

With Calculation Tools, you can apply the ABS function directly to all selected cells.

How to Convert Negative Amounts to Positive Values

1. Select the cells containing the expense amounts.
2. Go to ZKUTOOLS > Convert > Calculation Tools.
3. In the Calculation Tools:
   1. Choose Apply a Function.
   2. Select ABS.
   3. Preview the results. Then click OK or Apply.

   

The processed data becomes:

The ABS function is applied to the entire selected range at once, without creating formulas, filling helper columns, or copying results back to the original cells.

This method is especially useful when cleaning exported financial data, preparing expense reports, processing accounting records, or converting negative differences into positive values for further analysis.

Example 3: Calculate Selling Prices with a Markup and Handling Fee

Suppose you manage an online store and need to calculate selling prices based on product costs.

Your pricing policy requires you to:

1. Add a 30% markup to each product cost.
2. Add a fixed $5 handling fee.

The calculation logic is:

The original product costs are:

With Calculation Tools, you can use Custom to combine multiple operations and apply the calculation directly to the selected cells.

How to Calculate the Selling Prices

1. Select the cells containing the expense amounts.
2. Go to ZKUTOOLS > Convert > Calculation Tools.
3. In the Calculation Tools:
   1. Choose Custom.
   2. Type the formula as this: ?*1.3+5
   3. Click OK or Apply. (Preview not support in the custom mode)

   

The calculated selling prices are:

Instead of creating and managing formulas manually, the entire pricing calculation can be applied directly to the selected data.

The Custom option is particularly useful for pricing rules, cost adjustments, commissions, tax calculations, unit conversions, and other business scenarios that require multiple operations to be performed on existing values.

Calculation Tools vs. Standard Excel Online Calculations

Conclusion

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

Whether you need to add the same value to multiple cells, apply a function such as ABS, or create a custom calculation, the tool helps you complete the task without repeatedly creating formulas, filling helper columns, copying results, and pasting values back into the original range.

By combining arithmetic operations, built-in functions, custom calculations, and result previews in one convenient tool, Calculation Tools makes everyday numerical data processing in Excel Online faster and easier.

If you frequently work with existing numerical data and need to perform repetitive calculations or transformations, Calculation Tools can significantly simplify your workflow.