How to show calculation steps in Excel?
When you do some calculations in Excel, and if there gets some error results in the end, you can view the calculation steps to find out where goes wrong and then correct it.
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
In Excel, you can apply the Evaluate Formula function to view the calculation steps.
1. Select a single formula cell, and click Formulas > Evaluate Formula, Then an Evaluate Formula dialog pops out. See screenshot:
2. In the Evaluate Formula dialog, you can click Evaluate button to show the calculation steps. (Clicking the Evaluate button one time will display one calculation step.)
3. Then after viewing the calculation steps, you can click Close button to close the dialog.
Note: You also can click Step In to view each cell’s data, and then click Step Out to go back. (Each cell needed to click Step In once time.)
You are guest
or post as a guest, but your post won't be published automatically.
- To post as a guest, your comment is unpublished.· 24 days agoHi. i put sum formula in cell b2 containg 123+33 and in cell c2 25 and got total 25 in cell D2 .but i want actual total in cell d2 that is 181.how it will be possible..?
- To post as a guest, your comment is unpublished.· 2 years agoThanks a lot regarding the Evaluate Formula. Now i can attest that my MDAS computation is right. Thanks!