The following example shows a formula in cell D2 that multiplies cells A2, B2, and a discount derived from C2 to calculate an invoice amount for a sale. On the Home tab, in the Editing group, click Find & Select, and then click Go To.Ĭlick the arrow next to Paste Options, and then click Values Only.
How to select a range that contains the array formula If the formula is an array formula, select the range that contains the array formula. Select the cell or range of cells that contains the formulas.
If you accidentally replace a formula with a value and want to restore the formula, click Undo immediately after you enter or paste the value. When you replace formulas with their values, Excel permanently removes the formulas. Replace formulas with their calculated values
0 kommentar(er)
