Hide error values and error indicators in cells - Clean Up Mixed Case Text - Excel Tips and Tricks

Learn how to hide error values and error indicators in a cell.

By converting error values to a number (such as 0) or a descriptive text, and after that using a conditional format to hide the value, you can conceal error values. All to make it look professional and polished.

Here are the steps for more dynamic approach.
A) Hide Error Values
1) Select the cell
2) Enter formula
=IFERROR(B2/C2,"No Qty")
3) Apply to all cells

B) Apply Conditional Format
1) Select the cell
2) Home -- Conditional Formating
3) Highlight Cells Rules -- Text that Contains...
4) Enter "Qty"
5) OK
6) Apply to all cells

Here are the steps for a static text approach.
A) Remove #DIV/0 Error (Static)
1) Select any dataset cell
2) Ctrl+G
3) Special
4) Formulas
5) Leave only "Errors" checked
6) OK
7) Enter text "No Qty"
8) Ctrl + Enter
9) Apply to all cells


Hide error messages in excel,#DIV/0, division by zero error,
ignore errors in excel formula,remove all error indicators excel,how to hide value error in excel,excel if error then blank,how to remove error in excel formula,excel iferror,
ignore errors in excel formula,remove all error indicators excel,how to hide value error in excel,excel if error then blank,how to replace value with blank in excel formula,how to remove error in excel formula,excel iferror,excel formula error,

#excel #tips #shorts #fyp