Home >Topics >excel >What should I do if the excel table after the dotted line cannot be printed?

What should I do if the excel table after the dotted line cannot be printed?

藏色散人
藏色散人Original
2020-03-24 09:25:2145145browse

What should I do if the excel table after the dotted line cannot be printed?

What should I do if the excel table cannot be printed after the dotted line?

This is because the printed content is outside the page margins and cannot be printed. As long as the dotted line is adjusted to be outside the content that needs to be printed, it can be printed. The steps are as follows:

1. Use Excel to open the table where the dotted line needs to be adjusted. You can see a dotted line in the red box.

Recommended: "excel tutorial"

What should I do if the excel table after the dotted line cannot be printed?

2. Click the "View" menu and select "Distribution Preview" in the drop-down list.

What should I do if the excel table after the dotted line cannot be printed?

#3. The prompt "You can adjust the position of the page break by clicking and dragging the page break with the mouse" pops up, select "OK".

What should I do if the excel table after the dotted line cannot be printed?

#4. Then follow the prompts, select the blue dotted line and drag it to the edge of the required printing area.

What should I do if the excel table after the dotted line cannot be printed?

#5. In this way, the page breaks are adjusted.

What should I do if the excel table after the dotted line cannot be printed?

#6. Select "View" and click "Normal" to return to the starting view mode.

What should I do if the excel table after the dotted line cannot be printed?

#7. Now the dotted line is outside the area.

What should I do if the excel table after the dotted line cannot be printed?

#8. In this way, the content to the right of the dotted line is displayed during the print preview, and it can be printed.

What should I do if the excel table after the dotted line cannot be printed?

The above is the detailed content of What should I do if the excel table after the dotted line cannot be printed?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn