In this section you will learn about the options available for formatting a worksheet for printing.
The following topics are covered:
| On the ribbon tab Layout | group Page setup, you can, among other things, set the page format for the current worksheet. Here you can set such things as paper size, page orientation (portrait or landscape), and page margins. |
In the dialog box of the ribbon tab Layout | group Page setup  , you will find various settings on the Options tab for page numbers, print order, etc. and you can specify which parts of the worksheet should be printed. |
▪Setting up headers and footers
| Using the Header and footer command on the ribbon tab Layout | group Page setup, you can add a header and/or footer to the document, which will be printed at the beginning or end of each printed page of the worksheet. |
▪Adjusting page breaks manually
| Page formatting also includes the possibility to manually control the automatic page break if required. This can be done with the command Page break on the ribbon tab Layout | group Page setup. |
See the following pages for more information.