Here is a quick excel printing tip. Use the page setup options from print preview area of the spreadsheet to select how you want to handle the formula errors when the worksheet is printed (More on errors: understand and fix excel formula errors). You can set it to blank.
How to get to the above screen:
- Excel 2007: Office Button > Print Preview > Page Setup > “Sheet” tab
- Excel 2003 and before: File > Print Preview > Page Setup > “Sheet” tab
Read more quick tips, they are bite sized and take less than a minute to learn
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them)||Intraday Candlestick Charting [Stock Charts] »|