Methods for hiding errors on Excel worksheets

(Excel 2002+) Choose File → Page Seutp and click the Sheet tab. Select an option from the drop-down list that allows you to display Cell errors as.

Use conditional formatting. Select a range (e.g. the whole sheet by pressing CTRL+A and pay attention to what cell is 'active' (not highlighted) in your selection. In the conditional formatting, set Formula is and type =ISERROR(A1) (where A1 is the address of the active cell in your selection). Then click the Format button and set the font color to white. Then, if a cell is an error, it will display, but with a font color that matches the background of your sheet. Tricky, eh?

Create a presentation column, row, or sheet. The idea here is that you create a column, row, or sheet which uses a function such as =IF(ISERROR(A1),"",A1), where A1 points to the cell where all the real work is happening. This "presentation" cell simply decides whether or not to show the results of the "real" cell. You can then hide the real cell. You are basically using two cells to do the work--one does the calculation, one decides how to present it.