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

Contents

HOW TO PRINT TOP ROW ON TOP OF EVERY PAGE IN EXCEL ?

INTRODUCTION

When we are dealing with very lengthy reports, the final resort of any report is to get finalized and get printed on paper for the final show.
But EXCEL SHEETS sometimes pose problems while printing them as per our choice. We need to do a lot of settings before we can print the sheet as per our requirement.
The requirements can be , to print the sheet on one page, to print horizontally, to print vertically, to print both sides of paper, to print a portion, to print the header and footer , to print headings on every page and so on. The list is endless.
In this article, we are going to discuss one of the very required solution to print the top row of any sheet on every page of the print.
This solution is very important as when the reports go long, they need an identification.
So let us see how we can print the top row of a sheet on every page of the print.

STEPS TO PRINT TOP ROW ON EVERY PAGE OF THE PRINT IN EXCEL

STEP 1: GO TO PRINT TITLES BUTTON

The button for printing titles is located under the

PAGE LAYOUT TAB> PAGE SETUP SECTION

The location is shown below.

BUTTON LOCATION OF PRINT TITLE BUTTON IN EXCEL
EXCEL: EXAMPLE DATA AND BUTTON LOCATION: PRINT TITLES

STEP 2: CLICK PRINT TITLES BUTTON

THE FOLLOWING DIALOG BOX WILL OPEN.

REFER PICTURE: BELOW

STEPS:

  • Select the row to be repeated in the mentioned field. If we want to select the top row, select it or enter the address of the top row. The row can be selected using the mouse by clicking the symbol on the extreme right edge of the field which is shown in the picture below. In our case, the top row is $1:$1.
  • There are many other useful options but they are not needed in our case this time.
  • Click PRINT PREVIEW
  • It’ll take us directly to the PRINT OPTIONS page.
SELECT TOP ROW TO BE PRINTED
SELECT TOP ROW AND ENTER ADDRESS IN THE FIELD

STEP 3: PRINT PREVIEW

  • There are many other useful options but they are not needed in our case this time.
  • Click PRINT PREVIEW.
  • It’ll take us directly to the PRINT OPTIONS page.
  • The following animated picture shows the complete process.
SELECTING THE ROW AND CHECKING 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 top row.

PRINTING TOP ROW ON EVERY PAGE OF PRINT IN EXCEL
OUTPUT: TOP ROW 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: