When you open an Excel worksheet or transform any entrances or formulas in the worksheet, Excel immediately recalculates all the solutions in that worksheet by default. This can take a while if your worksheet is huge and also contains numerous formulas.

Nonetheless, if some cells consist of formulas whose worths will never change, you can conveniently convert these formulas to static worths, therefore quickening the recalculation of the spread sheet. We will show you an easy technique for changing an entire formula to a static worth and additionally a technique for changing part of a formula to a fixed value.

KEEP IN MIND: Keep in mind that if you convert a formula to a static value in the exact same cell, you can not go back to the formula. So, you may intend to make a back-up of your worksheet before converting formulas. Nevertheless, you can additionally copy formulas and paste them as worths into different cells, protecting your initial formulas. Also, if your worksheet is readied to compute formulas by hand, ensure to update your solutions by pressing F9 before duplicating the worths.

Select the cells which contain formulas you intend to transform to fixed values. You can either drag across the cell range, if they’re adjoining, or press Ctrl when choosing cells if they are not contiguous. Click Copy in the Clipboard section of the Home tab or press Ctrl + C to duplicate the picked cells.

Click the Paste switch in the Clipboard area of the Home tab and click the Values switch in the Paste Values section.

You can also pick Paste Special at the end of the drop-down Paste menu.

On the Paste Special dialog box, pick Values in the Paste area. This dialog box also supplies various other choices for pasting the copied formulas.

The selected cells currently include the results of the formulas as static worths.

Keep in mind, if you pasted over the very same cells, the initial solutions are no longer offered.

NOTE: If you just require to convert one cell (or a few as opposed to lots of) solutions, you can double-click in a cell consisting of a formula and also press F9 to transform that formula to a fixed worth.

If the outcome of a component of a formula will not change, but the results from remainder of the formula will differ, you can transform component of the formula to a fixed value while maintaining the rest of the formula. To do this, click in the cell with the formula and also choose the component of the formula you wish to transform to a static worth as well as press F9.

KEEP IN MIND: When picking part of a formula, be sure that you include the whole operand in your choice. The component of the formula you are converting should have the ability to be determined to a static worth.

The chosen component of the formula is transformed to a static worth. Press Enter to approve the fixed outcome as part of the formula.

Transforming solutions to static worths can be useful for quickening large spread sheets including a great deal of formulas, or for hiding the underlying solutions you utilized if you need to share the spread sheet with a person.