Read all our earlier excel tips
Many a times i have had this irritation that i didnt put an iserror forumla and prevented those little error symbols (#DIV/0! or #N/A) when i urgently printed out forecast statements. Even though I know they are harmless, I don’t want to have to explain them to a client/boss.
I was wondering if there was a way I keep them off my printed sheets without having to go through the trouble of rewriting those unimportant formulas to eliminate them or using iserror on simple excel sheets...
Here's how you can ensure these do not happen, these formulaes print because Excel is defaulted to print them, but you can change the default easily. In Excel 2003, click on File, Page Setup and then on the Sheet tab (see screenshot below). In 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.
When you go to the dropdown list next to Cell errors as, notice you have several choices:displayed prints the error values as shown in the worksheet;
All you need to do is, save your page set up on the excel sheet which you print and voila, errors don't get printed
If you have any questions on excel or want to know any shortcuts, do email them to us and we will revert back to you.
No comments:
Post a Comment