Written by Allen Wyatt (last updated May 2, 2020)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and 2021
If you are preparing worksheets that contain graphics, you may want to print the graphics on one version of the worksheet, but not print them on another. For example, you might be preparing a test for students, and the test requires them to draw a graph. You would want the printout of the student version of the test to leave space for drawing a graph, but the printout of the answer sheet should include the graphic showing how the students should answer.
The easiest way to handle this in Excel is to just turn off display of the graphics when you need to print the student test. In order to do this, create a single file that contains the questions and the answers. Assuming the answers are graphic files, follow these steps:
Figure 1. The Advanced area of the Excel Options dialog box.
You can now print your document, as normal. (Excel prints it very quickly since it doesn't need to send the graphics to the printer.) When you later want to see the graphics, repeat the steps, but make sure you specify that Excel should display the objects, in step 5.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6124) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and 2021. You can find a version of this tip for the older menu interface of Excel here: Hiding Graphics.
Best-Selling VBA Tutorial for Beginners Take your Excel knowledge to the next level. With a little background in VBA programming, you can go well beyond basic spreadsheets and functions. Use macros to reduce errors, save time, and integrate with other Microsoft applications. Fully updated for the latest version of Office 365. Check out Microsoft 365 Excel VBA Programming For Dummies today!
Excel is great at printing numbers on a piece of paper, but terrible at printing watermarks. This is apparently by ...
Discover MoreWant to "see through" an image you place on a worksheet? You can do so by using the steps in this tip.
Discover MoreWhen editing a worksheet, you can place comments or notes that are associated with individual cells. If you want, you can ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments