Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • Shapes with dynamic output Excel User tips
  • Dynamic selection list ActiveX controls
  • Extract Address into table Formulas - combined functions
  • BMI Calculator Basic Math
  • Get 3rd Wednesday of month Basic Math
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Excel Limits Excel User tips

Stale values (Scratched functions)

Posted on June 30, 2025 By ANmar No Comments on Stale values (Scratched functions)

Excel recently started to show cells with formulas scratched (see screenshot).

Looks like this new feature to tell user that these cells will have new values and they are in the process of getting calculated.

If you want to disable that feature, uncheck “Show stale values” in “Calculation Options” in “Formula” bar (Screenshot)

Excel User tips, Format Cells, Non-functions, Worksheet Tags:feature, formula, Non-Functions

Post navigation

Previous Post: Middle name + 1st name

Related Posts

  • Sheet() and Sheets() Lookup and References
  • Convert cell into textbox Excel User tips
  • Highlight dates dynamically AND
  • Scorring, saving multiple outputs in 1 number Basic Math
  • Excel ad from early 90s Non-functions
  • Excel sessions – 2013 VS 2010 Excel User tips

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • CONVERT function CONVERT
  • Repeated Offset Basic Math
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
  • Count how many times letter found Formulas - combined functions
  • Extract current (Active) workbook name CELL
  • CountIf limitation COUNTIF
  • New function IFERROR, finally IFERROR
  • VALUE() of LEFT() Formulas - combined functions

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme