How to Remove Green Lines After Copying an Excel Worksheet
Question details
The user needs to remove evenly spaced green lines that appear across the screen after copying an existing worksheet to a new tab.

- Product
- Spreadsheet
- Device & OS
- not provided
- Scenario
- Duplicating a worksheet tab for further data entry or formatting.
- Observed behavior
- Unexpected green lines, typically representing page break indicators or print-preview artifacts, are displayed across the newly copied sheet.
Verify whether your worksheet is currently set to Page Break Preview mode, as copying sheets with specific print boundaries often enables these visual indicators.
Switch to Normal View and Disable Page Break Indicators
This is the most common fix. Returning the worksheet to Normal view and explicitly disabling page breaks in the application options clears the green lines.
When you copy a worksheet that has an established print area, Excel may automatically display page break indicators as green or dashed lines. Adjusting the display settings for the specific worksheet will hide them.
Navigate to the View tab on the top ribbon and click on 'Normal' in the Workbook Views group to ensure you are not in Page Break Preview.
Click on 'File' in the top-left corner and select 'Options' at the bottom of the menu (or 'Preferences' if using a Mac).
In the Options dialog box, select 'Advanced' from the left sidebar and scroll down to the 'Display options for this worksheet' section.
Uncheck the box labeled 'Show page breaks' and click 'OK' to apply the changes. The green lines should now disappear.

Clear the Print Area
If the green lines represent a previously defined print boundary carried over from the original sheet, clearing the print area will remove the formatting.
Easily Manage Print Areas and Views in WPS Spreadsheet
WPS Spreadsheet provides a highly intuitive interface for managing your worksheet views, print areas, and page breaks without the hassle of visual clutter.
- 1. Open Your Document: Launch WPS Spreadsheet and open the file containing the unwanted lines.
- 2. Check Worksheet View: Go to the View tab and ensure 'Normal' is selected instead of 'Page Break Preview'.
- 3. Access View Options: Click on 'Menu' in the top-left corner, select 'Options', and navigate to the 'View' tab.
- 4. Disable Page Breaks: Under the Window options section, uncheck 'Page breaks' and click 'OK' to instantly remove the boundary lines.

Frequently Asked Questions
Why do green lines appear when I copy an Excel sheet?
These lines are usually page break indicators or print area boundaries. When you duplicate a worksheet, the print settings and view preferences (like Page Break Preview) are copied over, causing these lines to become visible.
How do I hide the standard gray gridlines in my spreadsheet?
To hide standard gridlines, navigate to the View tab on the ribbon and uncheck the 'Gridlines' box in the Show group.
Can I change the color of the standard gridlines?
Yes. Go to File > Options > Advanced. Scroll down to 'Display options for this worksheet', choose a new color from the 'Gridline color' dropdown, and click OK.




