Skip to main content
 

Excel Tips: Calculation & Formulas > Calculation Options

Author: Kelly Last Modified: 2019-07-16

Formula Errors

How to hide all error values in Excel?

How to hide error values in pivot table?

How to hide inconsistent formula error in Excel?

How to highlight all error cells in Excel?

How to ignore errors with Vlookup function in Excel?

How to median values ignore zeros or errors in Excel?

How to quickly rank values ignore errors in Excel?

How to quickly sum a column cells ignore #N/A errors in Excel?

How to remove divide by zero errors (#DIV/0!) in Excel?

How to replace # formula errors with 0, blank or certain text in Excel?

Ignore Blank or Zeros

How to not calculate (ignore formula) if cell is blank in Excel?

How to quickly calculate percentile or quartile ignore zeros in Excel?

How to rank data ignore zero values in Excel?

Show Formulas

How to show cell reference (as text) instead of value and vice versa in Excel?

How to show or hide formulas in cells of specified range/active sheet/all sheets in Excel?

Trace Arrows

How to delete tracer arrows in Excel?

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

How to highlight precedent or dependent cells in Excel?

How to show (formula) relationships between cells in Excel?

How to show arrows to display the relationship between formulas and cells in Excel?

How to show trace dependents or precedents arrow in Excel?

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

Update Formulas

How to keep/stop random numbers from changing in Excel?

How to only recalculate or refresh selected cells in Excel?

How to stop auto calculation in Excel?

How to update formula when inserting rows in Excel?

Others

How to show calculation steps in Excel?

How to use watch window to monitor formulas in Excel?