Hide Zero and Error Values

Hide Zero and Error Values helps you clean up worksheet display by hiding selected values that can distract from reading the table. It provides the tools you need to make data presentation clearer in sheets with many formulas or missing data, making your work more efficient and helping you accomplish tasks with ease. With Hide Zero and Error Values, you can hide cells that display 0 and cells that display the #N/A error, apply the setting immediately, restore the display by clearing the option, and keep the setting saved at the worksheet level. It changes only how cells are shown, without modifying actual data, formulas, or calculation results. Whether you're preparing data displays or reports, Hide Zero and Error Values helps you stay productive and complete tasks efficiently. Choose the documentation below that best matches your needs to learn more.

1:53