In this lesson we will look at three very useful tools Microsoft Excel: Print headers, work with footers, and insert page breaks. All these tools will definitely come in handy when preparing Excel document for printing or exporting to PDF format.

If your table has headings, especially when the table is large enough, it is very important that these headings appear on every page when printed. Read printed Excel workbook It will be very inconvenient if the headings are only on the first page. Team Print headings allows you to select specific rows or columns and print them on each sheet.

If you want to print certain parts of the workbook on separate sheets, you need to insert page breaks. There are two types of page breaks in Excel: vertical and horizontal. Vertical breaks are divided into columns, and horizontal breaks into rows. In our example, we will insert a horizontal page break.

When viewing a book in Normal mode, inserted breaks are represented by a solid gray line, while automatic breaks are indicated by a dotted line.

You can make your book more interesting and professional by adding headers and footers. Page header is located at the top of the page, and the footer is at the bottom of the page. Headers and footers contain information such as page number, date, book title, or section titles.

Excel uses the same tools for working with headers and footers as in Microsoft Word. Review the Guide to Working with Headers and Page Numbers in Word 2013 for more information.