123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Education >> View Article

Basic Excel: Recalculating A Sheet

Profile Picture
By Author: Chris Le Roy
Total Articles: 95
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

Microsoft Excel is an extremely dynamic application that by default automatically recalculates any changes you make to your Microsoft Excel worksheets. This capability in Microsoft Excel is called automatic calculation. Sometimes though you may find that due to the complexity and the size of your worksheet, you may want to control when the Microsoft Excel application recalculates your workbook or you may find that you just want a single worksheet to be recalculated.

To control when the Microsoft Excel application will recalculate the worksheet, you must first turn the default automatic calculation function to manual. The first step in doing this is to select the Tools menu and then select the Options command from the drop down menu. At this point the Options dialog box will appear.

Then select the Calculation tab in the Options dialog box and then select the Manual radio button. Finally to complete the process, of turning the automatic calculation off, press the OK button.

Once you are in manual calculation mode, there are a couple of ways you can force the Microsoft Excel application to recalculate. ...
... The first is to open the Options dialog, select the Calculations tab and then use either the Calc Now or Calc Sheet buttons. If you press the Calc Now button it will recalculate the whole workbook but if you press the Calc Sheet option it will only update your current worksheet.

Alternatively, you can recalculate your worksheet using shortcut keystrokes only at any time. These shortcuts are ones that you need to know as you may find it is better to operate your spreadsheet in manual mode than in automatic calculate mode. To update the whole workbook simply press the F9 key. If you want to update the active worksheet all you need to do simply press Shift + F9.

Total Views: 290Word Count: 307See All articles From Author

Add Comment

Education Articles

1. Can Ielts Academic Be Used For Immigration?
Author: lily bloom

2. A Course On The Importance Of Upskilling At The College Level
Author: stem-xpert

3. Global Clinical Trials: Unveiling India’s Booming Market Outlook For 2025!
Author: Aakash jha

4. The Power Of Micro-influencers: Why They Matter More Than Ever
Author: dev

5. Digital Marketing Course In Dadar
Author: Sanchi

6. The Best Sre Course Online In India | Sre Training
Author: krishna

7. Top Google Cloud Ai Training In Chennai - Visualpath
Author: visualpath

8. Best Dynamics 365 Business Central Online Training - Hyderabad
Author: Susheel

9. The Best Data Engineering Course In Hyderabad - 2025
Author: naveen

10. Microsoft Dynamics 365 Course In Hyderabad | D365 Training
Author: Hari

11. Top Salesforce Marketing Cloud Training In Ameerpet
Author: Visualpath

12. Top Snowflake Course In Ameerpet | Snowflake Online Training
Author: Pravin

13. List Of Top Online Ma Colleges In India
Author: Study Jagat

14. Scrum Master Training In Bangalore | Scrum Master Classes
Author: visualpath

15. Mendix Online Training | Mendix Online Certification Course
Author: himaram

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: