Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Shades of gray Graphics
  • Shapes with dynamic output Excel User tips
  • CamelCase to Camel Case CHAR
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Dynamic selection list ActiveX controls
  • Middle name + 1st name Basic Math
  • Paste Special Percentage Excel User tips
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF

Show developer tab

Posted on February 16, 2018 By ANmar

Starting Excel 2007, users are not getting easy access to developer stuff.

Not sure why is that, but we can go around that, so quickly, if you need to start developing inside Excel (using VBA) first thing to do is to show the “Developer” tab that came in hidden by default

Just follow on these steps

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Good luck programming

Excel User tips, Non-functions Tags:Excel2010, Excel2013, Non-Functions

Post navigation

Previous Post: Get monthly total from table with dates
Next Post: Count cells with condition – multiple conditions

Related Posts

  • Skills Grid Conditional Formatting
  • Pixel Excel Drawing Format Cells
  • When Excel tells you to go get some life Excel User tips
  • The Excel “&” bug Excel User tips
  • Blank (isempty) VS “” (null string) Excel User tips
  • Convert cell into textbox Excel User tips

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
  • Calculate hours between two cells ABS
  • Sort list dynamically (functions) COLUMN
  • Skills Grid Conditional Formatting
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • Comments versus Notes Excel User tips
  • Paste Special Percentage Excel User tips
  • Limited Ceiling Basic Math
  • Blank (isempty) VS “” (null string) Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme