Note: After pressing this shot cut key, all of the formulas in the worksheet which reference cells change will be updated at once.Īlso, you can run the following VBA code to only recalculate the selected cells in Excel.ġ. Then you can see the results of selected formula cells are updated at once. After changing values of reference cells, select the formula cells you need to recalculate, then press the F9 key. After changing values in column D or E, you need to recalculate the formula cells in Column F in order to get the new results. Supposing formulas locate in range F2:F10 as below screenshot shown. Only recalculate or refresh selected cells with VBA code Only recalculate or refresh selected cells with shortcut key In this article, we will show you how to recalculate or refresh only the selected cells in Excel. With the manual calculation mode, you need to recalculate the formula cells to get the updated result when changing reference cell values. How to only recalculate or refresh selected cells in Excel?įor frequently using complex formulas in Excel, many Excel users tend to change the workbook calculation from automatically calculating to manually.
