Tip: Quickly perform a calculation on all selected cells at once

Save 5 minutes a day by using the "Apply formula/calculation to selected cells..." tool:

Quickly apply a calculation to all selected cells at once

With: ASAP Utilities » Formulas » Apply formula/calculation to selected cells...

With this utility you can quickly perform a calculation on all selected cells at once.
Apply formula/calculation to selected cells

  1. There are many situation in which we think this becomes handy, we sure use it a lot ourselves.
  2. You can for example quickly multiply all cells in your selection by 1000 without having to add an extra column and enter a formula to do this.
  3. You can also use this for unit- or currency conversion by dividing or multiplying with the right conversion or exchange rate.
  4. Another example is to quickly update your price list at the end of the year.

Just select the cells and then in the Excel menu choose:
ASAP Utilities » Formulas » Apply formula/calculation to selected cells... or use the shortcut Control+Alt+i

How much time will it save?

It's guaranteed that you'll save yourself time and effort by using this tool. However, the actual time saved depends on much you use Excel, the amount of data you're working with and how often you use this particular tool.
You can easily see how much time ASAP Utilities has saved you so far.

Download

In case you don't have ASAP Utilities yet, you can download the free Home&Student edition (for personal use, students and charitable organizations) or the fully functional 90-day business trial from:
http://www.asap-utilities.com/download-asap-utilities.php

Comments are closed.

Pinterest