Sunday, February 17, 2013

How to Switch to Manual Calculation in Excel


1. Open Microsoft Excel and start a new blank workbook or open an existing workbook from your files.
2. Choose the 'Formulas' tab to display the 'Formulas' ribbon at the top of the screen.
3. Click the 'Calculation Options' button in the 'Calculation' section of the 'Formulas' ribbon to view the drop-down list of options. Choose 'Manual' from the list of options to switch to manual calculation. This will tell Excel that you want to switch from automatic calculation to manual calculation.
4. Enter your formulas into your Excel workbook as usual. When you press the 'Enter' key after typing a formula, it will no longer automatically calculate your formula without you specifically instruction it to.
5. Select the 'Calculate Now' button in the 'Calculations' section of the 'Formulas' ribbon. Every formula that you have entered into the current Excel workbook will now be calculated.

Blogger news