Tip: How to hide formula errors when printing a sheet

Did you know that when printing an Excel sheet, you can avoid printing errors like #VALUE! or #NAME! ?

Go to File --> Print --> Page Setup --> Sheet tab --> Cell errors as:

You can choose to either keep the error displayed as is, show the cell as blank, show as "--", or show as "#N/A".


No comments:

Post a Comment