When you print your worksheet, you probably don’t want
errors, such as #DIV/0, to appear on the printout. Before Excel 2002, if there
were errors on your spreadsheet, you had to set up a conditional format to hide
them. Now, it just takes a few mouse clicks to ensure they remain visible on
screen but not on paper.

Follow these steps:

  1. Go
    to File | Page Setup.
  2. On
    the Sheet tab, click the drop-down arrow of the Cell Errors As box and
    select <blank>.
  3. Click
    OK.

Now, when you print the spreadsheet, any cell that displays
an error on the screen will print out as a blank cell.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.