PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO PRINT HEADER ON ALL THE PAGES IN EXCEL

INTRODUCTION

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.

STEPS TO PRINT HEADER ON EACH PAGE IN EXCEL

Before learning , how to print header on each page, let us learn how to insert the header.
HEADER IS A TEXT , WHICH IS PRESENT ON THE TOP OF EVERY PAGE OF THE SHEET.
Let us first insert a header to our data.

STEP 1: INSERT THE HEADER

The button for printing titles is located under the

INSERT TAB> TEXT> HEADER & FOOTER

The location is shown below.

BUTTON LOCATION HEADER AND FOOTER
EXCEL:CLICK HEADER AND FOOTER BUTTON
After clicking the HEADER AND FOOTER BUTTON, following screen will appear.
The sheet will divide itself to different pages with THREE SPACES EDITABLE TO ADD HEADER IN THEM.
We can enter any text which we want to repeat in all the pages as HEADER while printing.
INSERT HEADER INTO THE PAGE
EXCEL:HEADER SCREEN. ENTER THE HEADER TEXT IN THE GIVEN SPACES

STEP 2: ENTER THE HEADER TEXT

In the picture above, we can see THREE DEDICATED PLACES for HEADER TEXT.
Enter the text in the headers.

STEP 3: PRINT PREVIEW

  • Go to FILE MENU>PRINT OPTION.
  • There are many other useful options but they are not needed in our case this time.
  • Check PRINT PREVIEW.
  • The following screen will appear
PRINT PREVIEW
HEADER PRINT PREVIEW

STEP 4: OTHER SETTINGS AND PRINT

If the preview is ok, Set the printer.

Set the number of copies needed.

Set other settings.

Click PRINT.

The output print will contain all the pages with HEADER PRINTED

OUTPUT OF PRINT HEADER ON EACH PAGE OF PRINT IN EXCEL
OUTPUT: HEADER PRINTED ON EVERY PAGE

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Share this:

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

  • PICTURES ARE TOO SMALL?? Don’t worry, Click them, and pinch zoom to see them properly. All pictures are in high resolution.
  • KINDLY LIKE OUR FACEBOOK PAGE BY CLICKING HERE  AND IF WE NEED TO IMPROVE, KINDLY SEND US THE FEEDBACK ON [email protected]
  • Didn’t get what you were looking for?? Just put your question in the chat box present in the Right Lower corner. Name and email id [No spamming, just for the answer of your requirement] are needed.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: