Probably the easiest way to not display errors like #VALUE! or #DIV/0! in an already existing worksheet is to use Conditional Formatting. Here’s how:

  1. Select all the cells you want to hide these error values in.
  2. Use Conditional Formatting from the Home tab, and select New Rule (there are other ways to get to the new rule, but this is the most direct)

  1. Select the Rule Type “Format only cells that contain,” then pick the Errors rule from the dropdown:

  1. Click the Format button, the font tab, and assign a white font!