How to number pages in excel. From a certain page, from the second sheet, taking into account the number of pages in the file

Numbering is a convenient way to create comfortable navigation that allows you to quickly navigate through a document. If the work is carried out in one table, then there is no need for numbering. True, if you plan to print it in the future, then it will be necessary to number it without fail so as not to get confused in the abundance of rows and columns. There are several options for pagination, which we will cover in detail in this article.

Simple pagination

This method is the simplest of all available and allows you to quickly number the pages. To do this, you need to do the following:

1. You need to activate the “Headers and Footers”, for this you need to go to Excel on the toolbar in the “Insert” section. In it, you need to select the “Text” item and only then use the “Headers and Footers”. An interesting point is that headers and footers can be placed both above and below, by default they are not displayed, and during the initial setup, you can set the display of information on each page of the table.

2. After going to the desired section, a special item “Headers and footers” will appear, in which you can edit the available settings. Initially, an area is available, divided into three parts at the top or bottom.

3. Now it remains to select the part of the header where the information will be displayed. It is enough to click on it with LMB and click on the “Page number” item.

4. After completing the steps, the following information will appear in the header: &[Page].

5. It remains to click on an empty place in the document so that the information you entered is converted into a page number.

6. It is possible to format the entered information. To do this, just select the data directly in the header and, after selection, go to the “Home” tab, in which you can change the font, increase the size, or change other parameters.

7. Once all the changes have been made, it remains to click on an empty area of ​​​​the file, and they will be applied to the header.

Numbering based on the total number of pages in the file

There is another way to number the pages in a document based on the total number of pages in the table. To do this, you will need to do the following:

1. Initially, you should use the recommendations from the first method exactly until the moment you go to the “Headers and Footers” section.
2. As soon as the first label appears in the headers and footers, you should edit it a little to get the following result: Page &[Page] from.

3. After finishing the inscription “from”, click on the “Number of pages” button on the toolbar at the top.

4. If everything is done correctly, then after clicking on an empty area of ​​the page, you will see a header that will display information about the page number and the total number of sheets.

Numbering from the second sheet

If you have previously written a term paper or a thesis, then you probably know the main design rule: the page number is not put on the title page, and the next page is affixed from the deuce. Tables may also need this design option, so we recommend that you do the following:

1. You need to activate the headers and footers, for this, use the recommendations from the first method.
2. Now in the section that appears, go to the “Parameters” item, in which you can check the box next to the “Special header for the first page” item.

3. It remains to number the pages in any of the ways that were considered earlier. True, for numbering, you should already select the second page to set up the header.
4. If you do everything right, you will get the desired result. In fact, the header on the first page will exist, it will simply not be displayed. Visual design will already start from the second page, as it was originally required.

This numbering option is suitable for the design of a variety of scientific papers and in the case of providing a table as an insert in a research paper.

Numbering from a specific page

A situation is also possible when it is required to start numbering not from the first page, but from the third or even the tenth page. Although this is extremely rare, it will not be superfluous to know about the existence of such a method, the algorithm of actions is as follows:

1. To begin with, it is necessary to produce basic numbering using one of the methods discussed above.
2. After completing the initial steps, you should immediately go to the “Page Layout” section on the toolbar.
3. Carefully study the section and pay attention to the inscription “Page Setup” at the bottom under the items “Print Area”, “Breaks”, etc. Next to this signature you can see an arrow, click on it.

4. A window with additional settings will appear. In this window, select the “Page” section, and then find the “First Page Number” item. In it you need to specify from which page you need numbering. Once everything is set, click on “OK”.

5. After completing the steps, the numbering will begin exactly with the number that you specified in the parameters.

If you want to remove the numbering, then simply select the information inside the header and click on “Delete».

Conclusion

The numbering procedure does not take much time and allows you to master these useful skills without any problems. It is enough to use the available recommendations indicated above to complete the task.