Write, Bureaucrats, Administrators
2,725
edits
Difference between revisions of "How to remove strikethrough from cells in BudgetLink"
Jump to navigation
Jump to search
How to remove strikethrough from cells in BudgetLink (view source)
Revision as of 16:26, 12 November 2024
, 12 Novemberno edit summary
| Line 1: | Line 1: | ||
= Overview = | = Overview = | ||
[[File:strikethrough_stale_values.png|300px|right|thumb|]] | [[File:strikethrough_stale_values.png|300px|right|thumb|]] | ||
In October 2024, Microsoft released an update that can make all cells in BudgetLink and Excel have '''strikethrough'''. | In October 2024, Microsoft released an update that can make all cells in BudgetLink and Excel have '''strikethrough'''. | ||
| Line 7: | Line 6: | ||
To disable stale values formatting and remove strikethrough from the cells, please follow the steps below. | To disable stale values formatting and remove strikethrough from the cells, please follow the steps below. | ||
<br clear=all /> | |||
== Steps == | == Steps == | ||
[[File:disable_stale_value_formatting.png|350px|right|thumb|select Manual calculation and uncheck Format Stale Values]] | |||
# In the Excel Ribbon go to the '''Formulas''' ribbon. | # In the Excel Ribbon go to the '''Formulas''' ribbon. | ||
# Click on '''Calculation Options''' drop down menu and uncheck '''Format Stale Values'''. | # Click on '''Calculation Options''' drop down menu and uncheck '''Format Stale Values'''. | ||
#: ''Do not change any other options.'' | #: ''Do not change any other options.'' | ||
<br clear=all /> | |||
== References == | == References == | ||
: [https://support.microsoft.com/en-au/office/stale-value-formatting-4b5c63c3-5dc7-4e9b-8e24-88bed1987dbd|Excel - Stale Values Formatting] | : [https://support.microsoft.com/en-au/office/stale-value-formatting-4b5c63c3-5dc7-4e9b-8e24-88bed1987dbd|Excel - Stale Values Formatting] | ||
<br \> | <br \> | ||