Omit Errors while printing data in Excel [ Microsoft Office ]
Lets say you have an excel files where there are lot of errors being displayed which would be calculative or conditional which would look really bad when you print it . If you want to skip it there is a very easy way to do it.
In Microsoft Office Excel 2007
- Go to Page Layout Tab and Select Print Titles
- Now select Print Section and See the Dropdown given for ” Cell Errors as “
- It can be optimum to select n/a or just blank while printing it. You can even give your own text.
Omitting Error prints in Microsoft Excel
So just relax in case you want to print your excel file clean and neat. Moreover there are comments also availble which you want to print but not along with the cell which would make things messy. You can select here to make it print at the end together.
Posted on 27th October 2008 by Ashish Mohta , A Professional Tech blogger, Editor and Writer who talks about solving day to day problems of people who use computer. He also writes on How to use the applications like Office, PC tips, Online tools,Browsers and more. All posts by Ashish Mohta | Connect with me @ Twitter | Linkedin | Facebook | Stumble
Sign up for our daily email newsletter
i have a problem:( how can i apply them ? plese answear need help
One Comment »
Leave your response!