How to Remove Print Lines in Excel: The Procedures Simplified

In this one, we’re going to go into detail about how to remove print lines in excel. Print gridlines generally indicate which portion of your sheet is going to get printed onto paper.

But here’s the thing.

Even when the printing is complete, the grid lines or print lines still remain in normal view mode. Yeah, it can get really annoying at times. But worry not, in this article, we’re going to talk about all the possible methods you can use to remove them.

There’s no point in waiting around. Let’s get to it.

Procedures to Remove Print Lines in Excel

Say, you just returned to normal view from page layout view or page break view. But still, you’re being able to see the dotted lines on your Excel worksheet. It’s obvious why you’d want to get rid of that. Don’t fret about it too much. The following methods should give you a clear guideline.

Unchecking the Page Break Option

This method should be by far the easiest method you’ll find. I mean really, there’s nothing to it. Let me guide you through the steps.

1. The first thing you’ll want to do is, go to the file option on the top left of Excel.

Unchecking the page break option 1

2. Once you click it, you’ll find the Option section on the bottom left of the menu.

3. After selecting options, you’ll find a separate window pop up. On that window, go to the Advanced option.

Unchecking the page break option 2

4. Once you’ve selected it, scroll down and look for the “Display options for this worksheet” section.

5. Under that. You’ll find the “Show Page Breaks” option. You’ll want to uncheck it.

Unchecking the page break option 3

6. Once that’s done, click “OK” and you should see that the print lines have disappeared.

Page Break Preview Option

The dotted lines or print lines can often cause half page prints. Sounds pretty annoying right? When simple options like “Reset all page breaks” fail you, you can simply utilize the page break preview option. Let me show you how to do it.

1. The first thing you’ll need to do is, select the view option on top of excel.

Page break preview option 1

2. Once you’ve done that, click on Page Break Preview. Once you’ve clicked on it, your Excel worksheet should look somewhat like the image below.

Page break preview option 2

3. Now, you can notice the dotted print line in the middle of the print preview.

4. Click and drag that line at the outer line of the preview.

Page break preview option 3

5. And that’s it, you’ve gotten rid of it. Now, your prints should come out just fine.

Reset The Print Area

Sometimes the print lines can really mess up your workflow. Especially when they look like the image below.

Reset the print area 1

To remove these lines, follow the step below.

1. Select a single cell on the worksheet.

2. Go to the Page Layout option on top of the worksheet.

3. Under that, you’ll find the print area option. Once you click it, there will be two options in the dropdown menu and one of them will be “Set Print Area.”

Reset the print area 2

4. Once you select that, a pop-up window will appear. Just click OK.

Reset the print area 3

5. And you’re done! You’ll find all the print lines removed straight away.

Use a VBA Code

If you don’t want to go through the options each time you want to remove the print lines from Excel, you can always choose to run a VBA code to solve the problem.

  1. Press Ctrl and F11 to bring up the VBA window in Excel.
  2. Once that’s out, click on the insert option and select “Module.”
  3. When the module window appears, just place the following code there.

Sub TogglePageBreaks()

ActiveSheet.DisplayPageBreaks = False

End Sub

  1. Run the code and the task should be complete.

A Few Guidelines

Before we part ways, let’s look into a few tips that might help you out with removing print lines in Excel.

  1. The methods that I’ve described will help you out with a dedicated work sheet. So, if you want to make them work on every work sheet, you’ll have to go through the procedure each time.
  2. The options that I have talked about in the article might be found in different places depending on the Excel version you’re using. So, you might have to do a bit of digging there.

Concluding Words

Removing the print lines from excel can prove to be rather necessary if you need to print a lot. Be it in office or with home tasks, these print lines can prove to be rather annoying. But hopefully, you’ve gotten a clear idea about how to deal with the issue.

Choose the method that’s to your liking. Not all of them might prove to be efficient for you. With that said, Let’s close things up for now. Until next time.

Leave a Comment