When we are printing the reports in Excel, there may arise a need to print some headings on all the printouts, so that the report can be tracked easily. In addition to the headings we might need to print page numbers, dates, some other details, author name or any information on the top portion or bottom portion of the report.
We can print any customized portion of the page repeatedly easily such as the top row of the report to repeat it over and again or we can put header and footer to be repeated on the print.
Header and Footer, themselves are present on all the pages, so they can be printed on all the pages easily.
In this article we’ll see separately , printing of different items on different parts of the page.
The button for printing titles is located under the
INSERT TAB> TEXT> HEADER & FOOTER
The location is shown below.
If the preview is ok, Set the printer.
Set the number of copies needed.
Set other settings.
The output print will contain all the pages with HEADER PRINTED
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE