Do you want in Excel large amounts of data Print, and then split them up on certain pages, is the Page break an indispensable tool. Such a change of side can automatically, manually set or removed again at certain points. About the function Pressure area establish it is possible to mark only individual areas for printing from large tables. How to use the page break and the print area correctly is described in the following.
The pagination preview
A small button in the lower right corner of the screen activates the page break preview . Initially, only the page breaks that Excel performs automatically are displayed.
Often, these settings need to be adjusted individually. This information message is also intended to remind you of that. So simply confirm with OK .
You can now see that Excel marks each page with a watermark . This is intended to help with orientation.
Edit the page break
To edit automatically placed page breaks , click and hold the left mouse button on a dashed line and drag it to the desired position. Manually changed and automatically placed page breaks can be distinguished by their line style . Dashed lines indicate automatically placed breaks, while solid lines indicate manually defined breaks.
Of course, manually inserted page breaks can also be moved or removed . To remove only a manual page break, right - click in the cell below or to the right of the broken page break and select " Remove Page Break" from the context menu.
To remove all page breaks , right-click in any cell to activate the context menu and select " Reset all page breaks".
Specify a print area
If you do not want to print the entire table or the entire data set, you can use the CTRL key and the left mouse button to select any number of different areas , and then define them as the print area by right-clicking.
Here you can see three arbitrarily sized areas that have been defined as print areas and are also watermarked . The blue borders of the print areas can be moved later using the mouse.
