Write, Bureaucrats, Administrators
2,725
edits
Difference between revisions of "How to remove strikethrough from cells in BudgetLink"
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 \> | ||