Eat whole foods: Whole foods are foods that havenât been tampered with, in the lab or the manufacturing plant. The foods you eat on this plan are straight from the farm: whole fruits and vegetables, whole grains, grass-fed and free-range meats, low fat dairy products, unsalted nuts, and seeds.
You need to replace its results with values. Just follow the simple steps below: 1  Select all the cells with formulas that you want to convert. 2  Press Ctrl + C or Ctrl + Ins to copy formulas and their results to clipboard.  3. Press Shift+F10 and then V to paste only values back to Excel cells.
(1) In the formula =AVERAGE($F$2:$F$15), $F$2:$F$15 are amount values in the Amount Column. (2) If you want to add the Grand Total line in the Pivot Chart, type Grand Total in Cell E1, and enter the formula =SUM($F$2:$F$15) into Cell E2 and drag the Fill Handle to Range E2:E15.