'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Remove Strikethrough from Stale Excel Formula Values
Question details
The user wants to disable the strikethrough formatting applied to formula results that are considered stale and need recalculation.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Managing formula calculation settings and disabling visual indicators for unrefreshed data.
- Observed behavior
- Excel applies a strikethrough formatting to formula results awaiting a refresh, which the user wishes to hide.
Keep in mind that removing this visual indicator means you will not easily see which formulas require manual recalculation before you refresh the data.
Disable 'Format Stale Values' in Calculation Options
Adjusting Excel's calculation options prevents the application from crossing out formula results that haven't been recalculated yet.
When Excel is set to manual or partial calculation modes, it uses strikethrough formatting to warn you that the data has changed but the formula has not updated. You can easily turn off this visual warning directly from the ribbon.
Click on the 'Formulas' tab located in the main Excel ribbon at the top of your screen.
Click on the 'Calculation Options' drop-down menu in the Calculation group.
Find and uncheck the 'Format Stale Values' option. The strikethrough formatting will immediately disappear from your unrefreshed formula results.
Easily Manage Formula Calculations with WPS Spreadsheet
WPS Spreadsheet offers intuitive calculation settings, ensuring your formulas are always up-to-date. You can easily switch between automatic and manual calculation modes without dealing with confusing visual artifacts.
- 1. Open WPS Spreadsheet: Launch WPS Office and open your spreadsheet file.
- 2. Go to the Formulas Tab: Click on the 'Formulas' tab located in the top ribbon menu.
- 3. Open Calculation Options: Click on the 'Calculation Options' drop-down button.
- 4. Select Automatic: Choose 'Automatic' to ensure your formulas update instantly whenever source data changes, preventing stale values entirely.
Frequently Asked Questions
Why does Excel put a strikethrough on my numbers?
In manual calculation mode, Excel crosses out (applies strikethrough to) formula results to indicate that the source data has changed. This means the formula result is now 'stale' and requires a recalculation to show the correct value.
How do I force Excel to recalculate stale formulas?
You can force a recalculation by pressing the F9 key on your keyboard, or by clicking the 'Calculate Now' button located under the Formulas tab in the ribbon.
Will disabling stale values formatting affect my actual spreadsheet data?
No, disabling the 'Format Stale Values' option only removes the visual strikethrough indicator. It does not change your underlying data or alter your current calculation mode.
Can I turn automatic calculation back on to avoid stale values entirely?
Yes. By navigating to the Formulas tab, clicking Calculation Options, and selecting 'Automatic', your formulas will calculate in real-time, preventing them from ever becoming stale.
