How to Hide Indefinite Errors in Excel

1. Open the Excel 2010 worksheet where you want to hide the error values. Click the top-left cell in the range of cells you want to work with, then hold 'Shift' and select the bottom-right cell. If you want to work with the entire worksheet, you can just click the box above the '1' on the end of the top row.
2. Select the 'Home' tab and click the 'Conditional Formatting' button at the top of the screen. Select 'New Rule' from the list that appears.
3. Click 'Format only cells the contain' from the list at the top of the New Formatting Rule window. Click on the drop-down box under 'Format only cells with' and choose 'Errors' from the list of options.
4. Click the 'Format' button and then select the 'Font' tab in the new window that appears. Select the drop-down box under the 'Color' heading and click the white box located at the top-left of the drop-down menu. Click 'OK' twice and the errors will disappear.
5. Click the 'File' tab at the top of the screen. Then click 'Options' on the left side of the screen.
6. Click 'Formulas' on the left side of the Options window. Locate the 'Error Checking' heading and click the box next to 'Enable background error checking' to remove the check mark. Click 'OK' and the small arrows will disappear from the cells with errors.