Tip of the Day | Thursday April 9th, 2026
Discover new tools to get things done.
Apply Calculation to Selected Cells...
This tool lets you quickly perform a calculation on a selected range without adding extra columns.For example, you can multiply all cells in your selection by 10 instantly. This tool supports various arithmetic operations, making it ideal for tasks such as unit conversions. You can also include cell references or functions in your calculation. For example, if a cell contains the value 100 and you enter '+SUM(G20:G40)', the cell's formula becomes =(100)+SUM(G20:G40).
You can enter many types of formulas, such as '/1000', '+50', '*2.54', '*A1', etc. A formula is built around the original value or formula in each cell. For instance, if a cell contains the value 25 and you apply a division by 100, the result becomes =(25)/100. The tool applies the new calculation only to cells with valid data, ignoring empty cells, text, errors, or array formulas. If the new formula would result in an error, you will be warned upfront and no changes will be made. Users of non-English versions of Excel can type arithmetic operations in their local language. For example, in the Dutch version of Excel, you can use a comma as the decimal separator and the localized function names, such as SOM() instead of the English SUM(). This tool remembers the last 100 calculations for easy reuse. By default, you can launch this tool using the Control+Alt+I shortcut.
Screenshots
Example screenshot: 1 Perform a quick calculation in selected cells
Example screenshot: 2 The result
Starting this tool
- Click ASAP Utilities › Formulas › 2. Apply Calculation to Selected Cells...
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.