What to do if dotted lines appear when printing in excel

Many friends will edit the record content in the excel table, but because some details are not handled well, there will be a dotted line when the table is printed. I want to remove this dotted line, and I have tried many methods but have not found an effective solution. About Everyone has encountered this problem. In this software tutorial, we will share the solution. Friends in need are welcome to check out the steps on the PHP Chinese website. Solution to dotted lines in excel printing: 1. Open the excel table that needs to be printed.

2. Then several options will appear. Among the options, we click on the file, and we will see the print preview option in the file. When we click on it, the printing interface will appear.

3. Then we choose to close and we will return to the original interface. In the interface we will see dotted lines such as the one shown below, which is not conducive to editing.

4. Of course, the above method only treats the symptoms but not the root cause. We need to solve this problem fundamentally. The first step is to find the tool in the drop-down triangle in the upper left corner. In the tool, we select the option.

5. In the options, we will see the view in the first option, and then we will see the automatic page break in the window options. We remove the previous check mark, and then cancel the dotted line.

The above is the detailed content of What to do if dotted lines appear when printing in excel. For more information, please follow other related articles on the PHP Chinese website!