Printing a document

If we want to print a large table, it will take up several pages of reports that we have sent to the printer. On that occasion, the table header appears only on the first page. The following text will show the technique used to adjust the layout of the report so that the header is repeated on all pages. Also, we will mention several more useful techniques for preparing for printing regarding quality and the presentation of certain elements of the report.

Header & Footer

Since Excel is often used to create business reports it would be useful to find information in the header or footer of the document that details them more closely. This can be: report name, label, company logo, date … And here you can insert the page number, the total number of pages, or some other information that is relevant to the appearance of the report. These functionalities contribute to the uniformity of the document and give it a more professional look.

Printing preparation options

The appearance of the table on the screen can be quite different from its appearance after printing. Therefore, Excel has several options that allow you to prepare document for printing by: determining page orientation, paper size, defining document margins, headers, footers, page numbers … Also, an existing document may be set fit desired number of pages. The listed options help us to make regular, transparent and functional reports.