Print a control on a worksheet

You may want to print a control because it contains data or images that you want to include on a printed document.

  1. If one or more controls is an ActiveX control:

    1. Make sure that the Developer tab is available.

      Display the Developer tab

      1. Click the Microsoft Office Button Office button image , and then click Excel Options.

      2. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

        Note: The Ribbon is a component of the Microsoft Office Fluent user interface.

    2. Make sure that you are in design mode. On the Developer tab, in the Controls group, turn on Design Mode Button image .

  2. Select the control or controls that you want to print.

    For more information, see Select or deselect controls on a worksheet.

  3. Right-click the selection, click Format Control, and then click the Properties tab.

  4. Select Print object.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×