Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • CTRL+Y a mini macro Excel User tips
  • Sort list dynamically (functions) COLUMN
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Spreadsheet Compare application Excel User tips
  • Formula Beautifier Excel User tips
  • Excel ad from early 90s Non-functions
  • Walking Columns ActiveX controls
  • CONVERT function CONVERT

Sheet() and Sheets()

Posted on August 22, 2018 By ANmar

Getting total number of sheets (Sheets), or ID of this sheet (Sheet). The two new formulas Sheet() and Sheets() can do well, yes not perfect, we still need to have function to list sheet names, but it is a start

Sheets() function will get you total number of sheets (in this workbook or certain workbook)

While Sheet will only return the ID of this sheet among sheets in this workbook

Lookup and References, Standard functions, Worksheet Tags:SHEET, SHEETS

Post navigation

Previous Post: Worksheet name, dynamically using formula
Next Post: Skills Grid

Related Posts

  • Always get 1st name (or last) Formulas - combined functions
  • Shades of gray Graphics
  • Count Unique COUNTIF
  • Workdays – Across months DATE
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions

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
  • Searching table in 2 dimensions. Formulas - combined functions
  • Workdays – Across months DATE
  • Get monthly total from table with dates DATE
  • CamelCase to Camel Case CHAR
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Jan8 date format AND
  • Dynamic selection list ActiveX controls
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme