Home >Topics >excel >An excel table is divided into two pages

An excel table is divided into two pages

尚
Original
2019-10-21 14:54:3338941browse

An excel table is divided into two pages

How to divide an Excel table into two pages:

1. First insert an excel table that needs to be printed in pages.

An excel table is divided into two pages

#2. You can see in the print preview that the table is displayed on one page.

An excel table is divided into two pages

#3. Return to the Home tab and move the mouse to the location you want to separate.

An excel table is divided into two pages

#4. Then click Page Layout, then click Separator, and click Insert Page Break.

An excel table is divided into two pages

#5. Finally, in the print preview, you can see that the table with all 1's is displayed on the first page.

An excel table is divided into two pages

#6. The table with all 2’s is displayed on the second page.

An excel table is divided into two pages

For more Excel-related technical articles, please visit the Excel Tutorial column to learn!

The above is the detailed content of An excel table is divided into two pages. 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