For example, the cell displays #N/A for value not available error, #DIV/0! for divide by zero error, #VALUE! for error in value, #REF! for invalid cell reference, #NULL! for cell references that are separated by space and etc.
Sometimes, these errors are expected. In these cases, you may want to hide the all those errors from the worksheets to make the things tidy and presentable.
To hide the errors when viewing the spreadsheet in Excel, we can make use of IFERROR function. IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.
IFERROR can evaluate error types of #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, and #NULL!.
If you only want to hide the error message when printing the sheet or workbook, you can choose to just hide the errors for the printout, and leave them visible in the spreadsheet.
To hide the error messages for Excel printout, click or tap on Page Setup in the Print menu. Go to the Sheet tab. Under the drop down menu of Cell errors as, select <blank> if you want to hide the error completely.
Alternatively, you may choose to display all errors as — or #N/A.
Hit OK when done, and now you can print your Excel spreadsheet without any errors.