How to number pages in Excel very quickly and easily

 The article below will guide you how to number pages in Excel.

1. How to number Excel pages from Page Setup

Step 1:

At the Excel interface, click on the Page Layout tab and then click on the arrow in the right corner in this settings group.

How to number pages in Excel very quickly and easily Picture 1

Step 2:

The Page Setup dialog box appears, click on the Header/Footer tab . Here users can choose to insert Excel page numbers at the top of the page, by clicking Custome Header. If you want to insert at the bottom of the page, click Customer Footer. Here I choose to insert at the bottom of the footer, so click Customer Footer .

How to number pages in Excel very quickly and easily Picture 2

Step 3:

The Footer dialog box appears. You will have 3 locations to place page numbers including Left section (left), Center section (middle), Right section (right). If you want to place the page number position, place the mouse cursor there and then click the Insert Page Number icon as shown below.

How to number pages in Excel very quickly and easily Picture 3

Step 4:

Immediately appears &[Page] in the position we selected before, click OK to complete.

How to number pages in Excel very quickly and easily Picture 4

Step 5:

Click OK to close the Page Setup interface. Now to check whether the page number has been inserted into Excel or not, click the Office icon on the interface and then select Print > Print Review .

How to number pages in Excel very quickly and easily Picture 5

Users will see page numbers appear in the document interface.

How to number pages in Excel very quickly and easily Picture 6

2. How to number Excel pages from any number

When numbering pages from any number, you can choose the sequential number you want for the page numbers. It is not required to number pages from number 1 because you can skip the introduction page, for example.

You also access Page Setup and in the First page number section, enter the page number you want to fill in.

We refer to the article How to number Excel pages from any number to know how to do it.

How to number pages in Excel very quickly and easily Picture 7

3. Number Excel pages using Excel Header/Footer

Inserting Header in Excel or inserting Footer in Excel is also very familiar to us. And in addition to adding information for Header and Footer, you can immediately insert page numbers.

Step 1:

On the Excel page, click Insert then look at the Text group and select Header/Footer .

How to number pages in Excel very quickly and easily Picture 8

Step 2:

Next click Page Number to insert the page number as shown below.

How to number pages in Excel very quickly and easily Picture 9

Step 3:

Immediately after that, choose the location where you want to place the page number and the page number will display in the Excel page.

How to number pages in Excel very quickly and easily Picture 10

4. Instructions for inserting page numbers in 1/2 style in Excel

Inserting page numbers in Excel 1/2 style applies to pages with the same content in 1/2 and 2/2 styles.

We will use the 1/2 page numbering character in Excel to set up.

You will click on the Insert Page Number icon and the / icon then click on the Insert Number of Pages icon .

Follow detailed instructions in the Instructions for numbering pages 1/2 on Excel.

How to number pages in Excel very quickly and easily Picture 11

5. Number Excel pages via View mode

This is also how to number Excel pages via Page Layout, but you access it from View mode. You will then see the option to number pages at the top or footer.

How to number pages in Excel very quickly and easily Picture 12

Then we can also choose the position to insert the page number we want to use.

How to number pages in Excel very quickly and easily Picture 13

Video tutorial on inserting page numbers in Excel

3.5 ★ | 2 Vote

May be interested

  • How to manage saved passwords on Microsoft Edge: View, delete, edit, exportPhoto of How to manage saved passwords on Microsoft Edge: View, delete, edit, export
    tipsmake introduces you to how to add, edit or delete saved passwords on microsoft edge web browser as well as export passwords as csv files.
  • Top 5 best Visual Voicemail applications in 2024Photo of Top 5 best Visual Voicemail applications in 2024
    voicemail transcription (transcript) is extremely convenient, allowing you to select voicemails instead of having to listen to all the messages you receive one after another. from a privacy perspective, the visual voicemail feature is very attractive because you can sneak a look at the voicemail content without having to listen to the message. below are the 5 best visual voicemail apps of 2024 for iphone and android.
  • How to connect Bluetooth headphones to computers and laptops 2024Photo of How to connect Bluetooth headphones to computers and laptops 2024
    connecting a bluetooth headset to a smartphone is quite a simple operation, but to connect to a windows computer, you need to do it manually. to help you easily use your wireless headset, tipsmake will show you how to connect your bluetooth headset to your computer in just a few clicks.
  • The 5 best microSD cards for Steam DeckPhoto of The 5 best microSD cards for Steam Deck
    having a good quality microsd card is essential to expanding the storage capacity on your steam deck.
  • 5 tools that should be on Quick Access Toolbar WordPhoto of 5 tools that should be on Quick Access Toolbar Word
    some useful tools you often use on word should be on quick access toolbar word for easier operation. below are 5 tools that should be on quick access toolbar word
  • Quickly fix the error 'This site can't be reached' on ChromePhoto of Quickly fix the error 'This site can't be reached' on Chrome
    if you are a windows user, when you encounter the error 'this site can't be reached' on your chrome browser, you will probably immediately think about losing your network connection and will immediately apply the solution to fix the network outage error with troubleshooter. however, this troubleshooting process only focuses on scanning the basics like the connection between the server and your computer and cannot check dns issues to actually resolve the problem. .