Excel: Remove an Object That Appears Only When Printing
Question details
The user needs to locate and stop a hidden arrow or other shape from appearing on an Excel printout.

- 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.
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.
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.
In Excel, select Home > Find & Select > Selection Pane. Review the listed objects and select the suspected arrow or shape, such as “Arrow: Down 1.”
With the shape selected, open the Shape Format tab, then open the Size and Properties dialog box. Expand the Properties section.
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.
Prevent VBA from copying the unwanted shape
Use this method when the arrow or shape returns after a macro copies a range or transfers content between worksheets.
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. Open the workbook: Launch WPS Spreadsheets and choose Menu > Open to load the Excel .xlsx workbook.
- 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. 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. Check Print Preview: Choose Menu > Print or press Ctrl+P, then review the preview and return to the worksheet if the object still appears.

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.




