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

Contents

HOW TO PRINT PAGE NUMBER ALL THE PAGES IN EXCEL

INTRODUCTION

Printing in Excel is a fun if we know the techniques to use them properly.
When we are dealing with lengthy reports, we need to repeat the column headers or row headers [ if the report is horizontal]
To fulfill  this requirement we have many options, like printing the top row or printing the header or footer etc.
But one of the frequent requirement is printing the page number of the report, date or time on the report.
In this article we’ll learn to print page number, date and time in every page of  the print.

STEPS TO PRINT PAGE NUMBER ON EACH PAGE IN EXCEL

To print the page number on each page in excel, we can make use of following options.
1. Using the HEADER OPTION [if we want the page number to be on the top of the page]
2. Using the FOOTER OPTION [if we want the page number to be at the bottom of the page].

SOLUTION 1: USING THE HEADER OPTION

STEP 1: INSERT HEADER AND FOOTER OPTION

The button for inserting header and footer is common. The location is shown below.

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 page in any of the space we want.
INSERT HEADER INTO THE PAGE
EXCEL:HEADER SCREEN. ENTER THE HEADER TEXT IN THE GIVEN SPACES

STEP 2: CHOOSE THE PAGE NUMBER TO INSERT AS HEADER

As we click the HEADER AND FOOTER button, a space for header will be created. Directly the DESIGN TAB FOR HEADER AND FOOTER will open.
If it is not open by default, click it.
Select the area of the header where you want to insert the PAGE NUMBER.
Click PAGE NUMBER as shown in the STEP 2 in the picture.
 
PRINT PAGE NUMBER ON TOP OF THE PAGE IN EXCEL
EXCEL:CHOOSE PAGE NUMBER FROM THE OPTIONS

After entering the page number, it’ll be visible on the pages as shown in the following picture.

SHOW PAGE NUMBER ON TOP OF PAPER
EXCEL:PAGE NUMBER SHOWN ON TOP OF PAGE

STEP 3: PRINT PREVIEW AND OTHER SETTINGS

  • 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.
  • If the preview is ok, Set the printer.
  • Set the number of copies needed.
  • Set other settings.
FINAL OUTPUT
LAST SETTINGS

STEP 4:PRINT AND OUTPUT

  • Click PRINT.

The output print will contain all the pages with page number printed on all the pages in a sequence.

OUTPUT
OUTPUT: PAGE NUMBERS ON THE TOP

SOLUTION 2: USING THE FOOTER OPTION

STEP 1: INSERT HEADER AND FOOTER OPTION

The button for inserting header and footer is common. The location is shown below.

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  AND THREE SPACES TO ADD FOOTER IN THEM.
This time we’ll go for the footer as we need the page number at the bottom of the page.
FOOTER INPUT SPACE IN EXCEL
EXCEL:INSERT FOOTER IN ANY OF THE MENTIONED SPACES

STEP 2: CHOOSE THE PAGE NUMBER TO INSERT AS HEADER

As we click the HEADER AND FOOTER button, a space for header will be created. Directly the DESIGN TAB FOR HEADER AND FOOTER will open.
If it is not open by default, click it.
Select the area of the header where you want to insert the PAGE NUMBER.
Click PAGE NUMBER as shown in the STEP 2 in the picture.
 
INSERTING PAGE NUMBER AT THE BOTTOM OF EACH PAGE IN EXCEL
EXCEL:CHOOSE PAGE NUMBER FROM THE OPTIONS

After entering the page number, it’ll be visible on the pages as shown in the following picture.

PAGE NUMBER SHOWN ON EVERY PAGE
EXCEL:PAGE NUMBER SHOWN ON TOP OF PAGE

STEP 3: PRINT PREVIEW AND OTHER SETTINGS

  • 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.
  • If the preview is ok, Set the printer.
  • Set the number of copies needed.
  • Set other settings.
PRINT SETTINGS IN EXCEL
LAST SETTINGS BEFORE PRINTING

STEP 4:PRINT AND OUTPUT

  • Click PRINT.

The output print will contain all the pages with page number printed on all the pages in a sequence.

PAGE NUMBERS AT THE BOTTOM
OUTPUT: PAGE NUMBERS AT THE BOTTOM OF EACH 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]

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: