How to Show or Delete the Print line in Excel

A page break is the divider that breaks a worksheet into pages. It is great when you format and print. Please see the steps below to setup or delete the page breaks.

You can also use the shortcut "Ctrl+P" to bring up the print window to show the print line.

Step 1: Click the "File" tab from the ribbon;

Step 2: Click "Options" from the left navigation menu;

Step 3: Click "Advanced" from the left navigation menu in the dialog box;

Step 4: To add the print line, you need to check "Show page breaks" under the section of "Display options for this worksheet";

  • uncheck the box to delete the print line;

Step 5: Click "OK" at the bottom to apply the changes.

Leave a Reply