Insert page number in excel. Paste page number in Excel

Excel documents are visually little different from each other; their main form is a table, and the purpose is the sorting and systematization of data arrays, assistance in accounting and economic calculations. Line numbering helps you arrange the printed pages of a document in order. If the table is small and fits on one A4 sheet, the question of how to number the pages usually does not arise. If the document contains long tables, then the printout produces a lot of sheets, so it’s easy to get confused. In this case, line numbering is insufficient for parsing papers; still need pagination.

Doing this in Excel is more difficult than, for example,. Unusual in comparison with Word is the use of special areas of the document - headers and footers into which the number is inserted; it’s not always clear how to number only part of the pages. Sometimes a desperate user manually numbers the contents without resorting to tools that automate the process. For short tables and occasional work in Excel, this approach can be justified. However, systematic work with large documents will require a skill that helps you quickly number the contents or remove the numbering. The steps to solve this problem depend on the version of Excel installed on the computer.

How to number pages in Excel 2003?

To date, more than a dozen versions have been released. Many users still have Excel 2003 installed. The location and functionality of the tools that allow numbering are significantly different from the capabilities of the latest versions. In Excel 2003, the numbering is done using the parameters panel mainly.

Issues with deleting the first page number in Excel 2003

Unfortunately, in the 2003 version, the developers did not provide for the possibility of separately on the first page, which often needs to be issued as the title page and remove the numbering.

When you try to remove the contents of the header from there, the numbering is deleted on the entire sheet of the Excel document. Therefore, the owners of this version have to come up with solutions to the problem, for example, someone offers in Excel to make the cover page in a separate file.

To make sure that the first page has a blank footer and the rest are numbered, it is convenient to use the Print panel (File - Print). In this panel, select the “Entire Book” radio button, and then click the “View” button in the lower left corner of the print panel. “The whole book” is all sheets, including the title page. A window will open in which you can see the entire contents of all sheets of the document. You can switch between them by clicking the "Next" and "Back" buttons in the upper left corner of the panel. If such a viewing showed that the numbering is in accordance with the plan, you can print the book.

How to make numbering in versions of Excel 2007 and 2010?

The principle of arrangement of tools and their names in Excel's latest versions are more logical and convenient. For example, the footer panel is not located in the View menu, but in the Insert menu. Headers and footers are not edited blindly, but in visual mode. And most importantly - now you can delete the number from the first page without having to create new sheets or documents; just check one box in the header and footer designer.

If you create a new sheet in the same document, you can do similar manipulations with numbers in it. Thus, within a single document, you can easily create many tables with title parts. Using new versions of Excel makes numbering pleasant, clear and easy to control.

In Excel, often you have to print the results of analytical work. It’s good when this is accompanied by several printed sheets, and if there are a lot of them, then there is a need to learn how to number the pages in Excel, so that after printing you can fold them correctly in the correct order.

For printing, data is numbered according to the specified format.

Excel is a spreadsheet editor, therefore, a solid table is placed and printed throughout the space, so it’s so difficult to figure out where the continuation of the table, and where its previous part. For this reason, many are actively looking for the answer to the question of how to make pagination in Excel.

Continuous numbering

Setting the numbers of all printed sheets is not difficult at all. Initially, of course, you should open the file in which pagination will be performed. In the upper part of the toolbar you need to find “View”, by default the application is accompanied by a normal view, in the submenu you need to select “Layout”.

After that, on the screen you can observe how the document is divided page by page. If the user is happy with everything, there is no need to edit something, you must go to the "Insert" section and select "Headers and Footers" there.

By activating this item, a context menu appears on the screen, allowing you to work with headers and footers. In the proposed list, you need to find the phrase "Page Number" by clicking on it.

If all the actions were carried out correctly, then such text as “& [Page]” will appear in Excel. This will indicate that numbers have been successfully added to the spreadsheet editor. It should be noted that by clicking on this text, it will immediately change and show the page order. If there is no information in this place, then you won’t be able to see the numbering, since only filled page spaces can be numbered.

Having completed in practice all the steps described in the recommendations on how to number pages in Excel, it becomes clear that no problems arise if you need to put down the numbers.

How to number from a specific place

Sometimes it becomes necessary to number not from the first sheet, but more often from the second. This is typical when the user performs a term paper or thesis, in which at the very beginning the title page is supposed to be placed. To correctly numbering under such conditions, it is useful to study the tips of experienced users on how to put page numbers in Excel, starting from the second sheet.

Numbering from a specific place

If you need to remove the numbering from the very beginning, you need to find “Special footer on the first page” in the header and footer designer, and then check the box next to it. Now it is only here that the footer will be subject to change, the rest will remain untouched. Removing the index manually manually will now be quite easy by clicking on it and clicking Delete.

In practice, everything becomes clear, and even an inexperienced user will be able to tell the same inexperienced comrades how to remove the document numbering in Excel.

However, in some cases, a specific need arises when the index must not be set even from the second, but from the seventh or some other position.

In order for the numbers to be printed not immediately, but starting from a specific sheet, you need to go to “Page Settings” and then go to the “Page” tab. In the lower part, it is important to find the text “First Page Number”, by default, “auto” is set there, which corresponds to the fact that pagination will be carried out from the first sheet. If it is necessary to make changes, instead of the word “auto” a numerical indicator is set out, indicating from which printed sheet the ordinal indicator will be affixed.

So, numbering page by page in Excel, using the tools of the office application itself is not difficult. It is enough to familiarize yourself with the recommendations, following which to go through the practical path of setting up a sequential page invoice.

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 how 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 \u200b\u200bthe 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 \u200b\u200bthe 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.

  October 4, 2017

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 how 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 \u200b\u200bthe 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 \u200b\u200bthe 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.

  Source: fb.ru

Relevant

Miscellaneous
Miscellaneous

By default, Microsoft Excel does not produce visible sheet numbering. At the same time, in many cases, especially if the document is sent for printing, they need to be numbered. Excel allows you to do this using footers. Let's look at the different options for how to number the sheets in this application.

Excel Numbering

You can number pages in Excel using footers. They are hidden by default, located in the lower and upper areas of the sheet. Their feature is that entries entered in this area are end-to-end, that is, they are displayed on all pages of the document.

Method 1: normal numbering

The usual numbering is to number all sheets of the document.

Method 2: numbering indicating the total number of sheets

In addition, you can number pages in Excel with their total number on each sheet.

1. We activate the display of numbering, as indicated in the previous method.
2. Before the tag we write the word “Page”, and after it we write the word “from”.
3. We place the cursor in the header field after the word “from”. Click on the “Number of Pages” button, which is located on the ribbon in the “Home” tab.
4. Click anywhere in the document to display values \u200b\u200binstead of tags.

Now we display information not only about the current sheet number, but also about their total number.

Method 3: second page numbering

There are times when you need to number the entire document, but only starting from a specific place. Let's figure out how to do it.

In order to set the numbering from the second page, and this is appropriate, for example, when writing essays, diploma and scientific works, when the presence of numbers is not allowed on the title page, you must perform the steps listed below.

1. Go to the footer mode. Next, we move to the tab “Header and footer designer” located in the block of tabs “Working with headers and footers”.
2. In the toolbar “Parameters” on the ribbon, check off the checkbox “Special footer for the first page”.
3. We set the numbering using the “Page Number” button, as already shown above, but do it on any page except the first.

As you can see, after that all the sheets are numbered, except the first. Moreover, the first page is taken into account in the process of numbering other sheets, but, nevertheless, the number itself is not displayed on it.

Method 4: numbering from the specified page

At the same time, there are situations when it is necessary for a document to start not from the first page, but, for example, from the third or seventh. Such a need is not often, but, nevertheless, sometimes the question posed also requires a solution.

1. We carry out the numbering in the usual way, by using the corresponding button on the ribbon, a detailed description of which was given above.
2. Go to the “Page Layout” tab.
3. On the ribbon, in the lower left corner of the Page Setup toolbar, there is an icon in the shape of an oblique arrow. Click on it.
4. The options window opens, go to the “Page” tab, if it was opened in another tab. We put in the field of the parameter “First Page Number” the number from which you want to number. Click on the “OK” button.

As you can see, after this the number of the first page in the document actually changed to the one specified in the parameters. Accordingly, the numbering of subsequent sheets also shifted.

Lesson: How to remove footers in Excel

Numbering pages in an Excel spreadsheet processor is pretty easy. This procedure is performed when the footer mode is on. In addition, the user can configure the numbering for themselves: format the number display, add an indication of the total number of sheets of the document, number from a specific place, etc.

We are glad that we were able to help you in solving the problem.

Ask your question in the comments, detailing the nature of the problem. Our experts will try to answer as quickly as possible.

Did this article help you?

Consider various ways as possible paginate   and make numbering   from an arbitrary document page in Excel.

When reading books, newspapers, or magazines, pagination allows you to conveniently navigate the structure of the text.
  So in Excel, when printing a document or report, page numbers simplify the perception of the text and do not allow to get confused in the order of the sheets.

How to insert page number in Excel?

You can insert page numbering in Excel using the footers located at the bottom and top of each page.
  To edit the headers and footers in the tab bar, select Page layout   and in the block Page settings   click on the icon in the lower right corner:

In the window that opens, we are interested in 2 tabs: Headers and footers   and Page.
  Let's dwell on the tab in more detail Headers and footers:

At the bottom of the window we can select individual parameters insert page number:

• Different footers for even and odd pages. For example, in ordinary books on the left page, the number is aligned to the left, and on the right page, respectively, to the right.
• Special footer for the first page.   This option is suitable for documents with a cover page, where the number is usually not put down.

Depending on the place where we want to put down page numbers, we choose Create Header   or Create footer:

In the window that opens, we can specify the insertion location on the page (left, center, right), as well as 2 options for displaying the number:

• &   - insert page number;
• &   - Insert the total number of pages.

For example, to insert the page number and their total number in the document in the lower right corner of each page, we write the text &/&   in the footer (the insertion point is on the right) and we get:

In addition to the page number in the footer, you can write plain text, insert the time and date, or add a picture.

How to make numbering not from the first page?

By default, page numbering in Excel starts from the first page, however, if we want to start numbering, for example, from the 5th, then we need to change the start page to start numbering.
  Go to the tab Page   using window Page settings:

In field First page number   set the initial sequence number we need, click OK and get the desired result.

Alternative way to insert a page number

You can also number pages in Excel in page layout mode (viewing a document in the form in which it will be printed). The layout mode is convenient in that it displays all the footers.
  To switch to this mode, in the tab bar, select Insert   and in the section Text   press Headers and footers:

Setting page numbering in layout mode is the same as in the above option.

Good luck and see you soon on the pages of the blog Tutorexcel.ru!

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 how 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 \u200b\u200bthe footer text with the page and in front of the tag there, enter “Page”, and after it “out”.
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 \u200b\u200bthe table to display the number of pages.

This was the second way to number the 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.

In this article we will discuss with you how you can number pages in excel 2010. If you have Excel 2003, then read the article: How to number pages in Excel 2003

Everything is quite simple. First you need to switch from "Normal" to "Page Layout" mode. This is necessary to visually see the numbered Excel pages, as well as to see how your Excel file will be divided into pages.

To switch to the "Page Layout" mode, go to the "View" section (see point 1 in Figure 1), then click on the "Page Layout" button (see point 2 in Figure 1), or you can switch to this mode and back with using the quick buttons (point 3 in figure 1)

After switching to this mode, let's see how to number pages in Excel. Go to the "Insert" section (see paragraph 1 in Figure 2), then select the "Headers and Footers" option (see paragraph 2 in Figure 2).

After clicking on this item you will be taken to the section on working with headers and footers.

To add page numbers in Excel   you need to click on the “Page Number” button (see point 1 in Figure 2). After clicking, you will see the following text “&” in place of the page number, which means that you inserted the page numbers into your Excel file. It is enough to click anywhere in the document and the text “&” is automatically converted to the page number.

Moreover, if there is no text in your file, the page number will not appear. Thus, you will see page numbers only on pages with text.

Often there is a need not to put the page number in Excel on the first sheet. This is necessary, for example, when the first sheet is a title page on which they do not put a number. Those pagination in Excel   should start from page 2.

In order to realize this, you need to put the “Special footer on the first page”, that is, such a footer, if changed, the other footers will remain unchanged. Therefore, you can delete the page number on the title page, the rest of the pagination will remain. To do this, check the box “Special footer on the first page” (see point 3 in Figure 2) and manually delete the page number on the first sheet.

How to start page numbering from another page (not the first)

If you need to start numbering from another page, for example, you want to start from page 6, then in this case you need to open “Page Settings”

To do this (Excel 2013), go to the “Page Layout” tab and click on the bottom corner with an arrow

The Page Setup window opens. To indicate Excel from which page you want to start numbering, in the "Page" tab, in the "First page number" field, instead of "Auto", put the page you need and click OK

If the article was useful to you, I will be grateful if you share it with your friends using the buttons below.