Page numbering in Excel 2016/2013/2010/2007

When doing word processing or working on Microsoft Office spreadsheets , one of the most important and necessary things is page numbering. Not only helps users easily manipulate, but the number of Excel pages also helps us manage and work more effectively.

We already know how to number pages in Word from the beginning or any page and on Excel spreadsheets can do the same. If you do not know how to do it, you can follow the quick guide below.

Number the Excel page

Microsoft Excel for Android Microsoft Excel for iOS Excel 2016

Step 1: From the interface manipulating Microsoft Excel spreadsheets, select the Page Layout tab , then click the left mouse button on the arrow icon in the bottom corner.

Page numbering in Excel 2016/2013/2010/2007

Step 2 : The Page Setup dialog box appears, select the Header / Footer tab , with two options corresponding to the two positions where we want to set the page number:

  • Custome Header : Put page numbers at the top
  • Customer Footer : Put page numbers at the end

Page numbering in Excel 2016/2013/2010/2007

Step 3 : For example, we choose to put the page number below ( Footer ), a corresponding dialog box will appear as below. At this time, we can also choose 3 different positions to number the page as we like, specifically:

  • Left section : Sets the page number to the left
  • Center section : Sets the page number in the center
  • Right section : Set the page number to the right

Page numbering in Excel 2016/2013/2010/2007

Step 4 : Want to put the page number where, select it and then click on the Insert Page Number icon .

Page numbering in Excel 2016/2013/2010/2007

Immediately you will see & [Page] of & [Pages] or & [Page] appear at that location.

Page numbering in Excel 2016/2013/2010/2007

Click OK to confirm the operation, then go to Print / Print Priview to preview the print and check the position we just numbered the page in Excel.

Page numbering in Excel 2016/2013/2010/2007

That's how we insert page numbers on a spreadsheet. If you want to make effective use of this office tool, this is one of the Excel tricks not to be missed.

Sign up and earn $1000 a day ⋙

Leave a Comment

Compare Microsoft Office 2016, Office 365 and Office Online

Compare Microsoft Office 2016, Office 365 and Office Online

What features do you get in the different versions of Office: Office 2016, Office 365, and Office Online?

6 useful Microsoft Office features that few people know about

6 useful Microsoft Office features that few people know about

Microsoft Office has a lot of features, but most people only scratch the surface. Even after a decade of use, people are still finding hidden gems that dramatically improve their productivity and workflow.

How to remove background online, remove photo background very easily

How to remove background online, remove photo background very easily

Removing photo background with web applications is very simple and the implementation is not complicated.

Microsoft Office is now available for free, but with one caveat!

Microsoft Office is now available for free, but with one caveat!

Microsoft now offers a Continue for free option if you don't want to work in a browser or pay a monthly fee.

How to enable dark mode in Microsoft Office on Android

How to enable dark mode in Microsoft Office on Android

Dark mode is becoming an indispensable feature on any application platform.

How to determine odd and even numbers in Excel

How to determine odd and even numbers in Excel

Determining even and odd numbers is one of the regular jobs of the accounting industry. The following article will guide people to determine odd and even numbers in Excel.

Reasons for choosing WPS Office to replace Microsoft Office

Reasons for choosing WPS Office to replace Microsoft Office

WPS is considered a worthy replacement for Microsoft Office. So what is the reason? What is better about this tool that makes users forget the unique name in the office tool market for more than 20 years in Vietnam.

How to download and install Microsoft Office 2019 for free

How to download and install Microsoft Office 2019 for free

Microsoft Office 2019 is about to launch in 2018. But we can also sign up for Microsoft Office 2019 in advance to get Microsoft Office 2019 as soon as it appears.

Instructions for deleting horizontal lines in Word

Instructions for deleting horizontal lines in Word

Word, an indispensable tool for office workers when editing documents and editing documents to create professionally presented and arranged documents, Word often comes with Excel and PowerPoint in the Microsoft Office suite, caters to many types

Fixed an error where the letter i automatically converted into the letter I in Word

Fixed an error where the letter i automatically converted into the letter I in Word

Surely many of us when writing text in Word have encountered errors where the lowercase letter i automatically switches to uppercase, right? This error is quite annoying, just typing back to fix it is very time consuming.

What is the difference between Excel and OpenOffice?

What is the difference between Excel and OpenOffice?

OpenOffice is an office suite built on open source. Like Excel, this toolkit can be used on computer systems using Windows or Linux operating systems.

How to share and cancel sharing Microsoft Excel files with others

How to share and cancel sharing Microsoft Excel files with others

Thanks to its handy features, Microsoft Excel of Microsoft Office has become one of the most commonly used office tools today. One of the advantages not to be missed by this spreadsheet tool is the ch feature

How to insert a PDF file into Excel

How to insert a PDF file into Excel

Adding PDF files to Excel will make working with this spreadsheet tool much more efficient and professional.

How to mix meeting invitations in Microsoft Word

How to mix meeting invitations in Microsoft Word

In Word, the text mixing feature is quite useful, helping users create meeting invitations, admission notices, announcements, payroll details for many people.

How to Safely Backup Your Password Manager

How to Safely Backup Your Password Manager

After years of relying on password managers, you know that even these trusted digital vaults are not immune to errors. When your password manager crashes or locks you out unexpectedly, backups become essential.

How to use Aperty to edit portrait photos

How to use Aperty to edit portrait photos

Many people use Aperty for portrait editing – it has traditional RAW development tools focused on editing portraits for great results and innovative AI tools dedicated to improving professional portraits.

How to arrange overlapping images in Word

How to arrange overlapping images in Word

Overlapping images in Word is very simple when you just need to adjust the image position in Word. The article below will guide you to overlap images in Word.

5 ways to open the Startup Repair tool on Windows

5 ways to open the Startup Repair tool on Windows

Startup Repair is a Windows recovery tool that can fix some system problems that prevent Windows from starting. Startup Repair scans your PC for problems and then attempts to fix them so your PC can start correctly.

4 reasons you need a tripod to take photos on your smartphone

4 reasons you need a tripod to take photos on your smartphone

While you can take many types of photos manually on your smartphone, there are some situations where a tripod will be needed.

How to listen to music privately on Apple Music

How to listen to music privately on Apple Music

Although Apple Music doesn't have an anonymous listening mode, we can also adjust some settings to be able to listen to music on Apple Music more privately.

How to use Gemini 1.5 Flash for free

How to use Gemini 1.5 Flash for free

At I/O 2024, Google announced a number of new AI models, upcoming projects, and a plethora of AI features that will be available across its products. However, the most notable one was the Gemini 1.5 Flash model.

How to use ChatGPT o3-mini for free

How to use ChatGPT o3-mini for free

The ChatGPT o3-mini inference model is now available for free to all ChatGPT users. OpenAI has added a Reason button next to the ChatGPT content importer to use the o3-mini model.

Scammers Are Using Deepseek to Steal User Data

Scammers Are Using Deepseek to Steal User Data

Bad guys are creating thousands of DeepSeek-like websites in the hopes that unsuspecting users will give them their personal information.

How to read five/five, four/four, one/one… correctly in the sequence of natural numbers?

How to read five/five, four/four, one/one… correctly in the sequence of natural numbers?

Five or five? Are you wondering whether reading two thousand twenty-five is correct? This article will give you the answer.

How to store avocado in the freezer

How to store avocado in the freezer

Freezing can help keep avocados fresher longer, but it can reduce their vitamin content over time. Here's how to best store avocados in the freezer.

Instructions to change the default File Explorer folder

Instructions to change the default File Explorer folder

By default, File Explorer opens to the Home folder, which contains recently used folders and files. If you want to change the default File Explorer folder, follow the instructions below.

Ways to reduce the risk of birth defects in the fetus

Ways to reduce the risk of birth defects in the fetus

Birth defects are something no one wants. Although they cannot be completely prevented, you can take the following steps to reduce the risk of birth defects in your baby.

What planets are Venus and Venus?

What planets are Venus and Venus?

What are the evening star and the morning star? Here's what you need to know about the evening star and the morning star.

Huawei Mate XT Ultimate screen repair price is as expensive as an iPhone 16 Pro Max

Huawei Mate XT Ultimate screen repair price is as expensive as an iPhone 16 Pro Max

According to the official price list announced by Huawei itself, repairing the Mate XT Ultimate screen will cost up to 7,999 CNY, equivalent to 1,123 USD or nearly 28 million VND, equal to the price of an iPhone 16 Pro Max.