Excel Tips : Hiding Errors on Printouts

 

Excel Tips : Hiding Errors on Printouts

 

 


Excel has a number of different errors that can appear in your worksheet, for any number of reasons. Errors values show up with a pound (hash) symbol followed by the type of error, as in #DIV/0! or #N/A.

When you print your worksheet, Excel prints the error values, by default. If you prefer, you can choose to have Excel not print the error values. Follow these steps:

  1. Choose Page Setup from the File menu. Excel displays the Page Setup dialog box. (If you are using Excel 2007, display the Page Layout tab of the ribbon and then click the small icon at the lower-right of the Page Setup group to display this dialog box.)
  2. Make sure the Sheet tab is displayed.
  3. Use the Cell Errors As drop-down list to specify how you want the error values printed.
  4. Click OK to close the Page Setup dialog box.

In step 3, you have several options in the drop-down list:

  • Displayed. Prints the error values as they show in the worksheet.
  • . Replaces the error value with a blank; effectively hides the error values.
  • --. Replaces the error value with two dashes.
  • #N/A. Replaces all error values with #N/A.
Replies (1)

nice one

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
Featured ARTICLESHIP 17 November 2026
Associate/ Article Trainee

M/s. A V C & Co.

New Delhi

CA Inter

View Details
Company
20 November 2026
Article

S & N CO

Mumbai

CA Inter

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details