The Calculate Now command on the Options menu causes every cell in the open
worksheet to be recalculated even when calculations are set to manual.
There are several methods to recalculate a single cell or range in
Microsoft Excel that do not cause the entire workbook to recalculate.
To recalculate a single cell in a worksheet, do the following:
- Place the cursor in the cell to be recalculated.
- Press the F2 key.
- Press ENTER.
The following is another option to recalculate a single cell in a
- Turn calculation to manual, that is, choose Calculation from the
Options menu and select the Manual option button. (In version 5.0,
choose Options from the Tools menu; choose the Calculation tab and
- From the Formula menu, choose Replace. (In version 5.0, choose
Replace from the Edit menu.)
- Enter "=" (without quotation marks) into the Replace text box
and "=" in the With text box.
- Choose Part from the Look At text box.
- Choose Replace (not Replace All).
To recalculate a single cell in a macro, use the following example:
Below is an example to recalculate a range in a macro. This example assumes
there are no arrays in the highlighted range and that the worksheet or
macro sheet with the data to be updated is active when the macro is
To recalculate only the cells in a single array, do the following:
- Select one cell in the array.
- From the Formula menu (ALT+R), choose Special (S) Current Array (A).
- Press the F2 key.
- Press CTRL+SHIFT+ENTER. These steps reenter the formula in the
array, updating the values they return.
There is an undocumented feature of Microsoft Excel versions 2.0 and 2.1
that allows you to recalculate two noncontiguous regions of a worksheet.
For more information on this feature, query on the following words:
selective and recalculation and manual and excel
Article ID: 61622 - Last Review: November 16, 2006 - Revision: 1.4
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0c
- Microsoft Excel 4.0c
- Microsoft Excel 3.0a
- Microsoft Excel 2.10d
- Microsoft Excel 2.1 Standard Edition
- Microsoft Excel 2.01
- Microsoft Excel 2.0 Standard Edition
- Microsoft Excel 5.0 Standard Edition
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.