Excel worksheet Print Line removal method

We often get the Excel worksheet printed, leaving a few dotted lines printed. As shown in the following illustration:

Many students reflect that they have tried a lot of operations but still can not be eliminated. Is there no other way than to reopen it?

You can do this:

In Excel 2010, click File-Options.

In Excel 2007, click the Office button in the upper-left corner, and then select Excel Options.

Click Advanced on the left side of the Options window, and then find the Show page breaks check box from the right window to clear the check box before checking it.

Now the print lines are gone.

Tips: The above settings are valid only for the current worksheet, and you need to reset the worksheet if you switch it.

Classification:

• Excel Tutorials