Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Links between two workbooks – dynamically using functions INDIRECT
  • 6174 Kaprekar’s constant Basic Math
  • VALUE() of LEFT() Formulas - combined functions
  • Excel Functions = XL f(x)s XLfxs
  • iframe in Excel (XLiFrame) ADDRESS
  • Blank (isempty) VS “” (null string) Excel User tips
  • Schedule column Basic Math
  • Calculate hours between two cells ABS

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

  • Paste Special Percentage Excel User tips
  • Formula Beautifier Excel User tips
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • Scorring, saving multiple outputs in 1 number Basic Math
  • SimpleANBox Basic Math
  • Expenses calendar, FaCal Basic Math

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
  • Rotate table using 1 formula ADDRESS
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Excel @ before function names in formulas Excel User tips
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Standard math to calculate Aspect Ratio Basic Math
  • FORMULATEXT to show formulas FORMULATEXT
  • IF with AND and IF with OR AND
  • 6174 Kaprekar’s constant Basic Math

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme