Best Microsoft Excel Bloggers

Tuesday, November 9, 2010

A lazy way to get rid of error messages

People spend a lot of time using IF statements and/or  IFERROR so that error messages do not show up in a spreadsheet but if you are in a hurry and need to present your data- here is a lazy way to fix it so that they don't display in a printed report.
Simply go to Page Setup and click on the drop-down beside Cell Errors as: and select

No comments:

Post a Comment

Ms. Excel- Resident Excel Geek