Formatting Issues

How to Remove Green Lines After Copying an Excel Worksheet

Algirdas JasaitisAlgirdas Jasaitis Nov 4, 2026 868 views

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.

How to Remove Green Lines After Copying an Excel Worksheet
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.
Before you start

Verify whether your worksheet is currently set to Page Break Preview mode, as copying sheets with specific print boundaries often enables these visual indicators.

Solution 1Recommended

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.

1
Switch to Normal View

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.

2
Open Application Options

Click on 'File' in the top-left corner and select 'Options' at the bottom of the menu (or 'Preferences' if using a Mac).

3
Navigate to Advanced Settings

In the Options dialog box, select 'Advanced' from the left sidebar and scroll down to the 'Display options for this worksheet' section.

4
Hide Page Breaks

Uncheck the box labeled 'Show page breaks' and click 'OK' to apply the changes. The green lines should now disappear.

Switch to Normal View and Disable Page Break Indicators
Worksheet-Specific Settings: The 'Show page breaks' setting applies only to the currently active worksheet. You may need to repeat this step if you copy additional tabs.
Seamless Spreadsheet 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. 1. Open Your Document: Launch WPS Spreadsheet and open the file containing the unwanted lines.
  2. 2. Check Worksheet View: Go to the View tab and ensure 'Normal' is selected instead of 'Page Break Preview'.
  3. 3. Access View Options: Click on 'Menu' in the top-left corner, select 'Options', and navigate to the 'View' tab.
  4. 4. Disable Page Breaks: Under the Window options section, uncheck 'Page breaks' and click 'OK' to instantly remove the boundary lines.
Free to use with comprehensive data analysis toolsFully compatible with Microsoft Excel (.xlsx and .xls) formatsClear, clutter-free view switching and print management
microsoft office alternative - wps office

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.