Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • GoLast to jump to last cell in a column CELL
  • Recover the unrecoverable Excel User tips
  • Edit directly in cell Excel User tips
  • Sum of divide – Array formula Array formula
  • State Abbr with Index+Match+Validation Data Validation
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Min Max vehicle Formulas - combined functions
  • Extract current (Active) workbook name CELL

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
Next Post: Calculate above and below me

Related Posts

  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • Sheet() and Sheets() Lookup and References
  • When Excel tells you to go get some life Excel User tips
  • Skills Grid Conditional Formatting
  • CTRL+Y a mini macro Excel User tips
  • Walking Columns ActiveX controls

Leave a Reply Cancel reply

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

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

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 (83)
    • 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 (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • 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 (6)
      • Average (1)
      • 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
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Insert Blank rows into table using functions CHAR
  • Scorring, saving multiple outputs in 1 number Basic Math
  • Calculate above and below me Average
  • VALUE() of LEFT() Formulas - combined functions
  • Excel sessions – 2013 VS 2010 Excel User tips
  • CamelCase to Camel Case CHAR
  • CONVERT function CONVERT

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme