Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Multiple-Validations (connected to each other) Data Validation
  • Insert Blank rows into table using functions CHAR
  • OFFSET+MATCH Formulas - combined functions
  • CamelCase to Camel Case CHAR
  • Searching table in 2 dimensions. Formulas - combined functions
  • Excel ad from early 90s Non-functions
  • Edit directly in cell Excel User tips
  • Excel Functions = XL f(x)s XLfxs

Tag: limits

Excel Limits

Posted on February 13, 2020June 30, 2025 By ANmar
Excel Limits

Worksheet and workbook specifications and limits For more limits of VBA inside Excel, check out http://BoldCodes.com/?DevID=26CFPFO4LB Feature Maximum limit Open workbooks Limited by available memory and system resources Worksheet size 1,048,576 rows by 16,384 columns Column width 255 characters Row height 409 points Page breaks 1,026 horizontal and vertical Total number of characters that a…

Read More “Excel Limits” »

Excel User tips, Non-functions, Worksheet

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
  • Week number to Sunday date – Weeknum reverse DATE
  • Shades of gray Graphics
  • Stale values (Scratched functions) Excel User tips
  • Min Max vehicle Formulas - combined functions
  • Fixed length ID Formulas - combined functions
  • Expenses calendar, FaCal Basic Math
  • Spreadsheet Compare application Excel User tips
  • Multiple lines in cell using functions CHAR

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme