Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • 0% interest promotion Basic Math
  • Tally chart in functions Formulas - combined functions
  • 6174 Kaprekar’s constant Basic Math
  • Limited Ceiling Basic Math
  • Filter. Google Sheets function Google Sheets
  • Paste Special Percentage Excel User tips
  • Links between two workbooks – dynamically using functions INDIRECT
  • Hyperlink usage and HyperlinkOf UDF CELL

Category: Excel User tips

When Excel functions are not enough

Posted on February 13, 2020 By ANmar
When Excel functions are not enough

BoldCodes

BoldCodes is here to help (BoldCodes.com or Bold.Codes), even though I doubt it, I mean the fact that you cannot do your task in Excel formulas. especially after you understand 25% of these formulas.

But when you do, check out the library of VBA/Excel (aka macros, aka vbscripts) programming codes at BoldCodes.com or Bold.Codes

Excel User tips, Non-functions, XLfxs

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

When Excel tells you to go get some life

Posted on January 29, 2019 By ANmar
When Excel tells you to go get some life

This is what happens when you spend too much time in Excel

Go have a break and get some life

Read More “When Excel tells you to go get some life” »

Excel User tips, Non-functions, Worksheet

Recover the unrecoverable

Posted on January 23, 2019 By ANmar
Recover the unrecoverable

Working a lot with Excel means seeing lots of errors and bugs inside Excel

Some of those are not likely bugs, but more like reaching the limit of the application.

Read More “Recover the unrecoverable” »

Excel User tips, Worksheet

Edit directly in cell

Posted on December 5, 2018 By ANmar
Edit directly in cell

One of the settings that I always change when I first get a new Excel installation is …

Remove “Edit directly in cell”

Here is where you find that option

Read More “Edit directly in cell” »

Excel User tips, Non-functions

Convert cell into textbox

Posted on March 28, 2018 By ANmar
Convert cell into textbox

Often times, I found myself the need to design a sheet where I want users to input something, and I need them to focus on that particular single input (or more)

So, i learned a trick, it is formatting the entire sheet to certain color and give that cell special format to make it look like a textbox.

Read More “Convert cell into textbox” »

Excel User tips, Graphics, Non-functions, Worksheet

Show developer tab

Posted on February 16, 2018 By ANmar
Show developer tab

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

Read More “Show developer tab” »

Excel User tips, Non-functions

Excel sessions – 2013 VS 2010

Posted on June 9, 2017 By ANmar
Excel sessions – 2013 VS 2010

Excel 2010 was great because you can easily open another Excel session while your current session is working.

This allowed us to run multiple tools at the same time, since those two sessions are separated and do not touch.

However, starting Excel  2013, the interface changed, making it harder to run new session or open Excel while we have another Excel session running some long process.

Read More “Excel sessions – 2013 VS 2010” »

Excel User tips, Non-functions

Posts pagination

Previous 1 2

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
  • Text-to-Columns, dynamically using formulas IFERROR
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • Insert Blank rows into table using functions CHAR
  • Shades of gray Graphics
  • Multiple lines in cell using functions CHAR
  • Cuts string of list of items Formulas - combined functions
  • Hello world! Uncategorized
  • OFFSET+MATCH Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme