How to remove printer lines in Excel

You can watch a video tutorial here.

When printing an Excel sheet, it is a good practice to check what the print-out will look like by using the Print Preview window. By doing this, you can check that the data fits neatly on the printed page. After using Print Preview, the page breaks appear as faint dotted lines on the sheet. Here we see how to remove those lines.

Step 1 – Check if the page breaks appear

– Check if the page breaks appear

Step 2 – Open the Excel Options window

– Go to File > Options 

Step 3 – Disable Show page breaks

– Select the Advanced option
– Scroll down to Display options for this worksheet
– Uncheck the Show page breaks box

Step 4 – Check that the lines have disappeared

– The printer lines are no longer visible