Do you want in Excel size 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

 

With a small one button at the bottom right of the screen you can see the Page break preview activate. Initially, only the page changes that Excel makes automatically are displayed here.

Often these settings have to be adjusted individually. These Info message should also point out again. So just go with it OK to confirm.

You can now see that Excel is starting the individual pages with a Watermark marked. This is supposed to be the Orientation serve.

 

Edit the page break

 

Would you like the automatically set Page breaks now! Bearbeiten, you go with depressed Links Mouse button on such dashed Line, and pulls it to any position. Manually changed and automatically set page breaks can be found on the Line style recognize. Dashed Lines are the Automatically set and Solid lines are manually specified areas.

Of course you can too manually set Page breaks postpone another time or else remove. To remove just a manual page break, click the right-wing Mouse button into the cell below or to the right, and select the command in the context menu Page break cancel.

One would like Page breaks remove, you activate with right-click the context menu in any cell and select All Page breaks reset.

 

 

Specify a print area

One would like not can all Table or to print the entire data record, there is the option with depressed Control key and the left Mouse button any number of different Areas to mark, and then use a Right click as a Pressure area to be determined.

Here you can now see three arbitrarily size Areas, as Pressure area set have been, and also here with one Watermark Mistake. the blue frame the print areas can also be checked later with the mouse move.

___________________________________________________
This tip comes from www.win-tipps-tweaks.de
© Copyright Michael Hille

Warning:
Using Registry Editor or its tips incorrectly can cause serious system problems that may require you to reinstall your operating system. Tampering with the registry files and using the tips is at your own risk.