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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!