How to Take Print Without Objects?

Worksheet with object            

Print without object

print excel, printing in excel, excel print, excel printing, printing from excel, print excel sheetprint excel, printing in excel, excel print, excel printing, printing from excel, print excel sheet

Follow the steps below if you do not want to print objects in a worksheet.

Suppose you have some data and a button in your worksheet and you want

only the data to be printed without the button.

Right click on the button which you do not want to print and select ‘Format Control’.

print excel, printing in excel, excel print, excel printing, printing from excel, print excel sheet

Select Properties in ‘ Format Control’ . Uncheck ‘ Print Object’ .

print excel, printing in excel, excel print, excel printing, printing from excel, print excel sheet

Click OK.

When you select the ‘print preview’, Now you can see the print out without the object.

print excel, printing in excel, excel print, excel printing, printing from excel, print excel sheet

—————————————————————————————————————

Vani is a Business Associate with p2w2, a Spreadsheet Solutions company. p2w2 has expertise in Excel Modeling, Excel Dashboards, Profitability Analysis,  Excel Invoices and Excel Bid sheets. You can contact us by email: cs [at] p2w2.com or call us at 305.600.0950.

Leave a Reply

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