Excel Tips: Developer > Macro or VBA

Calculation & Formulas

Calculation & Formulas > Calculation options

How to hide inconsistent formula error in Excel?

How to highlight all cells referenced by a formula in Excel?

How to only recalculate or refresh selected cells in Excel?

How to stop auto calculation in Excel?

How to trace precedents or dependents for a range of / multiple cells in Excel?

Calculation & Formulas > Math Functions

How to keep running total in one or a single cell in Excel?

How to quickly sum values excluding hidden columns in Excel?

How to round a range of cells in Excel?

How to round range of numbers to even in Excel?

How to sum cell values in a column until blank cell reached?

How to sum range of cells ignoring errors in Excel?

How to sum up values from textboxes?

Calculation & Formulas > Statistical Functions

How to count blank cells or nonblank cells in a range in Excel?

How to count cells with specific text and fill/font color in Excel?

How to count files in a certain folder/directory in Excel?

How to count number of cells with comments in Excel?

How to count number of peaks in a column of data in Excel?

How to count number of times a cell is changed in Excel?

How to count or sum cells based on cell color in Google sheet?

How to count the line breaks in cell in Excel?

How to count the number of printed pages in a sheet?

How to count the number of sheets of a workbook?

How to count the number of visible sheets in a workbook?

How to count the number of words in a cell or a range cells in Excel?

How to count the page numbers of Pdf files in Excel?

How to count total clicks in a specified cell in Excel?

How to count total rows in a table in Excel?

How to count worksheets with specific name in Excel?

How to count/sum cells by colors with conditional formatting in Excel?

How to quickly count the number of all opened workbooks?

How to quickly count the number of hidden worksheets in Excel?

Calculation & Formulas > Others

How to add values to multiple cells in Excel?

How to batch rename multiple range names in Excel?

How to change/convert absolute reference to relative reference in Excel?

How to create dynamic named range in Excel?

How to divide a range of cells by a number in Excel?

How to double click a cell and add 1 to that cell value in Excel?

How to find most common value (number or text string) from a list in Excel?

How to find or get the cell reference of the previous active cell in Excel?

How to find where a certain named range is used in Excel?

How to get the address of active cell in Excel?

How to hide / unhide all named ranges in Excel?

How to lock all cell references in formulas at once in Excel?

How to lookup/find values in another workbook?

How to quickly delete all named ranges in Excel?

How to remove time from date in Excel?

How to replace formulas with results or value in Excel?

How to resize an existing named range in Excel?

How to vlookup and return matching value with cell comment?