How to Insert Page Numbers in Excel (in the Header or Footer)

How to Insert Page Numbers in Excel

In today’s tutorial, we’re going to go through how to insert page numbers, in the header or in the footer – wherever you need in Excel spreadsheets.

Let’s get started!

Would you rather watch this tutorial? Click the play button below!

How to Change the View Mode of the Document to See Header and Footer

First of all, we need to change the view mode of the document, so we’ll go to the View tab and click on ‘Page Layout’.

How to Insert Page Numbers in Excel - Change the View Mode of the Document to See Header and Footer

Now we see the options ‘Add header’ and ‘Add footer’. If you click on any of the two, you’ll see that they’re divided into three sections where you can insert page numbers.

How to Insert Page Numbers in Excel - Header
How to Insert Page Numbers in Excel - Footer

How to Insert Page Numbers in Excel

Here we want to insert page numbers in the header on the left, so we click into the left part of the header, then we go to the Header & Footer tab on the Ribbon and select ‘Page Number’.

How to Insert Page Numbers in Excel -Click in to the Header
How to Insert Page Numbers in Excel - Header & Footer tab
How to Insert Page Numbers in Excel - Select Page Number

As you can see, there’s no number, but Excel uses a code instead. If we now click anywhere within the document area, the header will show the number of the page there.

How to Insert Page Numbers in Excel - Excel uses a code
How to Insert Page Numbers in Excel - click anywhere within the document area to see the number of the page

How to Add a Total Page Count to the Page Numbers

To add a total page count to the page numbers, simply click into the header again, type in a forward slash to separate the two numbers and then click on ‘Number of Pages’.

How to Insert Page Numbers in Excel - click into the header again, type in a forward slash
How to Insert Page Numbers in Excel - click on ‘Number of Pages’

Again, we can see a code here, but once we click outside the header area, what shows after the page number is the number of pages separated with a slash – just as we wanted.

How to Insert Page Numbers in Excel - shows the number of pages separated with a slash

You can do the same in the footer of the document, too.

And let’s have a look at a couple of more interesting tips you might find useful when inserting page numbers.

How to Format the Page Numbers

First, we’ll have a look at formatting – you can format page numbers to fit the document style.

Let’s select the page numbers and in the Home tab we can change the font type or size.

How to Insert Page Numbers in Excel - change the font size
How to Insert Page Numbers in Excel - change the font type

How to Start the Numbering on Page Two

If you need to make the header or the footer of the first page different and start the numbering on page two, it can be done in a quick and easy way.

Click into the header, open ‘Header & Footer’ and select ‘Different First Page’, which allows you to modify the header or the footer on the first page and, at the same time, this will not affect the headers and footers on the rest of the pages.

How to Insert Page Numbers in Excel - select ‘Different First Page’

How to Remove Page Numbering from the Header or Footer

And of course, you can remove page numbering from the header or footer anytime. Simply click on it, highlight it and press Delete – that’s all it takes!

How to Insert Page Numbers in Excel - remove page numbering from the header
How to Insert Page Numbers in Excel - delete

After you’re done with the page numbers and formatting, you can return to the regular view through the View tab, selecting the view ‘Normal’.

How to Insert Page Numbers in Excel - return to the regular view selecting the view ‘Normal’

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published. Required fields are marked *

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.