How to number pages in Excel: four ways

The article will tell you how to number the pages in Excel. The fact is that by default their numbering is absent, but most often, especially if the document is sent to some companies or for printing, page numbers should be indicated. This is done quite simply, and there are many ways. At the end of reading the article, you can independently choose the method you like for yourself.

Method One: Simple Numbering

So, now we’ll look at a simple way to number pages in Excel, but using it you can put page numbers on absolutely all pages, so if you need different numbers on different pages, it won’t work for you.

To paginate, you need to:

1. Include headers and footers. This is done in the corresponding menu, which is located in the "Insert" tab, go there.
2. In the toolbar, find the "Text" group and click on the "Header and Footer" button.
3. As soon as you do this, headers and footers will appear on the sheets. They are located below and above, just like in the Word. However, there are differences. So, in "Excel" they are divided into three parts. You at this stage need to choose in which place the page number will be.
4. After you have decided on the location, you need to go to the designer (the tab that appears) and find there and click on the "Page Number" button.
5. After that, a special tag will appear in the area you have selected, you do not need to modify it at all, you just need to click the mouse anywhere in the table.

This was the first way to number the pages in Excel. As you can see, it is very simple. With it, you can quickly put down numbers in the entire document.

Method two: display the total number of pages

By the way, the article discusses ways to number pages in Excel 2007, however, the instructions are the same for all versions, some buttons and their location may differ.

So, to put down the numbering indicating the total number of pages in the document, you need to do the following:

1. Put a simple numbering. To do this, refer to the previous instructions.
2. Now go into the edit area of ​​the footer text with the page and in front of the tag there, enter “Page”, and after it “from”.
3. Now place the cursor after the word "from", after indenting.
4. Go to the "Design" tab and click on the "Number of pages" button. It is located under the "Page Number" button.

Now, as in the previous time, you just need to click on an arbitrary area of ​​the table to display the number of pages.

This was the second way to number pages in Excel, the third in line.

Method three: pagination of all pages except the first

Now we will tell you how to put page numbers in the entire document except the first sheet.

1. Go to the "Headers and Footers" tab.
2. On the toolbar, click on the "Options" button and check the box next to "Special footer for the first page."
3. After that, number the pages as described above.

As you can see, all pages got their number, except the first. If there is a desire, then it can be numbered separately, or you can leave it empty.

Fourth method: numbering from a specific sheet

So, if you want to start numbering from a specific sheet, you need to:

1. Make a simple numbering, as described in the first method.
2. Go to the Page Layout tab.
3. Click on the icon in the form of an arrow pointing to the lower right corner, which is located in the page settings tool group.
4. In the window that appears, on the "Pages" tab, put the number from which the numbering of the document will begin. This is done in the "First Page Number" field.
5. Click OK.

After that, the first page will receive the number that you specified. By the way, if you’re thinking how to number the pages in Excel 2003, then, as mentioned above, the instructions are common to all versions.