Convert formulas to values

By default, all cell references in Excel are relative. When you copy such a formula to another cell, the references change based on relative positions of rows and columns. This works fine most of the time, but in some cases, you may need to lock the column and row coordinates so that your formula always refers to a specific cell. This is done by using absolute references. Our tool can change all references in all selected cells to absolute or relative in one go.

In case you want to improve Excel performance or are sharing your worksheet with someone, you may want to replace formulas with their results. The add-in can do this as well.

Sure. To replace a formula with its calculated value in a single cell, you can simply delete the formula and type the result manually. In a range of cells, this can be done by using the Paste Special > Values option.

With our tool installed in your Excel, you can change all selected formulas to their values in a single button click.

Of course, you can. You can select a cell with your formula, enter the Edit mode, and then type or delete the $ sign manually. Or, select the reference you want to change and press F4 on your keyboard to toggle between 4 reference types. And then, you repeat the above steps for every single cell.

With the Convert Formulas tool, you simply select a range of cells and click just one button on the ribbon to change all references in all formulas.

1. Select the range with formulas.
2. On the Ablebits Tools tab, click Convert Formulas > To Values.

See a more detailed description here.

1. Select the range with formulas.
2. On the Ablebits Tools tab, click Convert Formulas > To Absolute.

See a more detailed description here.

1. Select the range with formulas.
2. On the Ablebits Tools tab, click Convert Formulas > To Relative.

See a more detailed description here.