Printing Problems

Excel: Remove an Object That Appears Only When Printing

Elise WilliamsElise Williams Nov 12, 2026 868 views

Question details

The user needs to locate and stop a hidden arrow or other shape from appearing on an Excel printout.

Excel: Remove an Object That Appears Only When Printing
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet prints a blue arrow or another object that is not visible during normal worksheet editing, possibly because the object is hidden, stored on another sheet, or copied by VBA.
Observed behavior
An unwanted shape appears in the printed output even though it is not readily visible on the worksheet.
Before you start

Open Print Preview and check each worksheet that contributes to the print area. If the workbook uses macros, identify whether the object appears after a macro runs before changing the worksheet layout.

Solution 1Recommended

Locate the shape and disable its printing property

Use this method when the unwanted arrow or shape exists on the worksheet but is difficult to select directly.

The Selection Pane lists objects on the active worksheet, including shapes that may be hidden behind cells or other objects. Clearing the object’s printing property keeps it available for editing without including it in printed pages.

1
Open the Selection Pane

In Excel, select Home > Find & Select > Selection Pane. Review the listed objects and select the suspected arrow or shape, such as “Arrow: Down 1.”

2
Open shape properties

With the shape selected, open the Shape Format tab, then open the Size and Properties dialog box. Expand the Properties section.

3
Stop the object from printing

Clear the Print object check box, close the dialog box, and use File > Print to confirm that the shape no longer appears in Print Preview.

Keep the shape on the worksheet: Clearing Print object hides the shape from printed pages without deleting it from the workbook.

Remove unwanted printed shapes in WPS Spreadsheets

WPS Spreadsheets lets you inspect worksheet objects, adjust their properties, and verify the result in Print Preview. It also supports Excel workbooks, making it easy to troubleshoot unwanted arrows or shapes without changing your original workflow.

  1. 1. Open the workbook: Launch WPS Spreadsheets and choose Menu > Open to load the Excel .xlsx workbook.
  2. 2. Find the unwanted object: Select the worksheet, open the Home tab, and use the object or selection management pane to identify the arrow or shape listed on the sheet.
  3. 3. Change the object’s print setting: Select the shape, open its Format or Size and Properties options, and clear the setting that allows the object to print.
  4. 4. Check Print Preview: Choose Menu > Print or press Ctrl+P, then review the preview and return to the worksheet if the object still appears.
Locate worksheet shapes through the object or selection management tools before printing.Control whether a selected shape is included in printed output.Use Print Preview to verify the final worksheet appearance.Open and save Microsoft Excel .xlsx files with broad format compatibility.
microsoft office alternative - wps office

Frequently Asked Questions

Why does an arrow appear in Excel Print Preview but not on the worksheet?

The arrow may be hidden behind cells or other objects, located on a different worksheet, or added by a macro. Open Home > Find & Select > Selection Pane to list objects on the active sheet.

How can I keep an Excel shape on the worksheet but prevent it from printing?

Select the shape, open Shape Format > Size and Properties, expand Properties, and clear Print object. The shape remains in the workbook but is excluded from printed pages.

What should I do if the unwanted shape comes back after running a macro?

Inspect the macro for a full-range Copy operation. Replace it with PasteSpecial using xlPasteValues or transfer cell values through a VBA array so drawing objects are not copied.

Can I remove the object instead of only hiding it from printouts?

Yes. Select the object in Home > Find & Select > Selection Pane and press Delete. Use this only when the shape is not needed elsewhere in the workbook.

How do I confirm that the object will not appear on paper?

Select File > Print in Excel and inspect Print Preview for every relevant worksheet. If the object is still visible, check its print property and whether another copy exists on a different sheet.