Write, Bureaucrats, Administrators
89
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 21:56, 10 November 2024
, 10 Novemberadded a image to display strikethrough. changed default calculation from Partial to Manual
m |
m (added a image to display strikethrough. changed default calculation from Partial to Manual) |
||
| Line 1: | Line 1: | ||
= Overview = | = Overview = | ||
[[File:strikethrough_stale_values.png|350px|right|thumb|uncheck '''Format Stale Values''']] | |||
[[File:disable_stale_value_formatting.png|350px|right|thumb|uncheck '''Format Stale Values''']] | [[File:disable_stale_value_formatting.png|350px|right|thumb|uncheck '''Format Stale Values''']] | ||
Microsoft recently released '''Stale Value Formatting''' for Excel on Windows. | Microsoft recently released '''Stale Value Formatting''' for Excel on Windows. | ||
| Line 10: | Line 11: | ||
== Steps == | == Steps == | ||
#In the Excel Ribbon under '''Formulas''' click on Calculation Options drop down button and uncheck '''Format Stale Values'''. | # In the Excel Ribbon under '''Formulas''' click on '''Calculation Options''' drop down button and select '''Manual''' calculation. | ||
# In the '''Calculation Options''' drop down menu, uncheck '''Format Stale Values'''. | |||
# Strikethrough will be removed from all cells. | # Strikethrough will be removed from all cells. | ||