The dotted line in paging preview cannot be dragged

The dotted line in the page break preview cannot be dragged

Sometimes Excel will have a situation where the dotted line in the page break preview cannot be dragged. Let’s see how to solve it.

The difference between dotted lines and solid lines:

The solid line is the actual page break, that is, the content within the solid line is to be printed on one page. If it appears The dotted line frame is smaller than the solid line frame. Please note that the area outside the dotted line cannot be printed. At this time, you need to drag the dotted line to change the size of the printing range.

The dotted line cannot be dragged:

1) First check whether the drag and drop function is enabled. If this function is not enabled, you cannot move any page breaks. Specific steps:

Open the Excel document——>Click the “File” tab, find the lower right corner of the pop-up box——>“excel options”——>“Advanced”—— >Check "Enable fill handle and cell drag-and-drop functionality" and click OK. Then go to modify and drag the page break.

2) In addition: There is another situation where the page break dotted line cannot be dragged, that is, the computer is not connected to a printer. After testing, it has been found that the page break dotted line cannot be dragged without the printer being connected.

Recommended tutorial: excel tutorial

The above is the detailed content of The dotted line in paging preview cannot be dragged. For more information, please follow other related articles on the PHP Chinese website!