Preventing The Printing Of Objects In Microsoft Excel 2010

In this article, we will learn how to prevent the printing of objects in Microsoft Excel 2010.

Sometimes there is some object like Combo Box in the workbook that you want to be displayed while you are working, and, at the same time, you want the Combo Box to disappear while taking printout reports.

For example, I have a Sales Report that contains multiple dropdown options & selecting any one of them, the formulas in the workbook will work in such a way that it gives an impression of Dynamic or Interactive update of reports to the end user. The Combo Box option can be used to store multiple dropdown criteria. The fact of the matter is: I want to use Combo Box to view the updation of reports, but I do not want to see the Combo Box while printing.

Objects such as text boxes, shapes, and pictures all have a default setting of objects will print. If you do not want them to print then, you can change the settings from Properties.

 

In this example, we will show how to prevent Text Box from printing.

Let us draw a Text Box:

 

  • Click on Developer ribbon
  • In Controls group, click on Insert
  • Select Text Box (ActiveX Control)

 
img1
 

  • Right click on Text Box & select Format Control

 
img2
 

  • Select Properties tab
  • Deselect Print object

 
img3
 

  • Click OK
  • Press CTRL + P shortcut key for printing
  • You will not see the Text Box.

 
img4
 
To prevent printing of objects like Combo Box while printing a report from Page Layout ribbon, follow the below-mentioned steps:
 

  • Click on Page Layout ribbon
  • Click on Print Titles or click Dialog Box Launcher in the bottom-right corner of Page Setup group

 
img5
 

  • The Page Setup dialog box will appear

 
img6
 

  • Select Sheet tab
  • In Print group, select the Draft quality

 
img7
 

  • Click on Print Preview to see the preview

 
Before applying setting, we are able to view Combo Box
 
img8
 
After applying setting, we are not able to view Combo Box
 
img9
 
 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube