Replacing a formula with its result can be helpful if there are many or complex formulas in the workbook and you want to improve performance by creating static data. You can convert …

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.

Select the cell that contains the formula. In the formula bar , select the reference that you want to change. Press F4 to switch between the combinations. The table summarizes how a reference …

To change or edit an array formula, you need to follow some rules, especially if you have multi-cell formulas. This article spells out the rules.

Learn how to use the percentage formula in Excel to find the percentage of a total and the percentage of change between two numbers. Try it now!

If you use a lot of complex formulas in your Excel spreadsheet, you should learn about recalculation options, iteration (calculating repeatedly), and precision.

A formula that contains a relative cell reference changes as you copy it from one cell to another. For example, if you copy the formula =A2+B2 from cell C2 to C3, the formula references in C3 …

You can replace a formula with its calculated value so that the formula no longer recalculates. Replacing a formula with its static result can help improve performance if the workbook …

Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can …

Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.