How To Insert Page Number In Excel – A Quick Guide

There might be situations where you need to keep a note of the number of pages.
Inserting page numbers in worksheets can help you with that.

Let’s see, how to do that quickly…

Various possible operations are

1. Insert page numbers on a single worksheet
2. Insert page numbers in multiple worksheets
3. How to set the starting page number
4. Removing the page numbers from worksheets

1. Insert page numbers on a single worksheet

Inserting page numbers can be done on a single worksheet and on multiple worksheets based on our requirement.

Let us do it for single worksheet first…

Step 1: Select the worksheet to which you want to insert page numbers

Page Number in excel -1

Step 2: On the Insert tab, Text Group, click Header & Footer
OR
Directly click on Pay Layout View button at the right bottom beside the zoom scroll bar.

By now, you must be in Page Layout View

Page Number in excel -2

Step 3: Now then first click on Add Header/Add Footer and select Design Tab to display Header & Footer Tools

Page Number in excel -3

Note: You have a choice to place the page numbers at  Left section, Center section, or Right section box of the header or footer.

Step 4: In the header & Footer Elements group, select the Page Number button
The &[Page] text will be added to the Header/Footer as per the choice
If you want to add the total count also, then just add &[Pages] to the text above or just click on Number of Pages button.

Page Number in excel -4

Step 5: Now just click somewhere in the body of the Excel to come out of the edit mode and its done.
Note: In case you want to exit from the Pay Layout View, just click on Normal View

Page Number in excel -5


2. Insert page numbers in multiple worksheets

 

Step 1: Select all the worksheets that you want

Step 2: On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher

Page Number in excel -6.PNG

Step 3: In the Page Setup window, on the Header/Footer tab, click the Custom Header/Custom Footer based on your choice.

Page Number in excel -7.PNG

Step 4: select the Page Number button
The &[Page] text will be added to the Header/Footer as per the choice

If you want to add the total count also, then just add &[Pages] to the text above or just click on Number of Pages button.
Finally, click on “Ok”

Note: You have a choice to place the page numbers at  Left section, Center section, or Right section box of the header or footer.

Page Number in excel -8.PNG


3. How to set the starting page number

We have the full control on the starting page number and it can come handy in many of the situations too.

Step 1: Click Page Layout tab, then in  Page Setup group, click the Dialog Box Launcher

Step 2: Select Page tab, and then change the First Page Number value from Auto to some desired numeric value and finally click “Ok”

Page Number in excel -9.PNG


4. Removing the page numbers from worksheets

Sometimes you may want to delete the page numbers that you or someone else has put into the worksheets.

Just a few steps and its done…

Step 1: Select the worksheets for which you wish to remove the page numbers

Step 2: In the Page Setup window, on the Header/Footer tab, select the drop-down list under Header/Footer label based on your choice and set the (none) value from the list and click “Ok”.

Page Number in excel -10

What are you waiting for, Give it a try buddy!!!

Hope the article has helped you…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: