» Hiding Errors in Cells Before Printing
CATEGORY - Excel Printing
VERSION - Microsoft Excel 2002
1. Select the Print Area in the Sheet, and from the Format menu, select Conditional Formatting.
2. In Condition1, select Formula Is.
3. In the Formula box, type =ISERROR(A1) (assuming the print area starts at cell A1).
4. Click Format and select the Font tab.
5. In Color, select white and click OK.
6. In the Conditional Formatting dialog box, click OK.
To hide errors in cells before printing in Excel 2002 and Excel 2003:
1. From the File menu, select Page Setup.
2. Select the Sheet tab.
3. From Cell errors as, select blank, and then click OK.
Book Store:
Recommended Books:
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Microsoft Windows XP Step by Step (With CD-ROM)
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Mortgages For Dummies®
No comments have been submitted.
