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.

Leave a Comment

How to Use Microsoft Office on Chromebook for Free

How to Use Microsoft Office on Chromebook for Free

As you know, Chromebooks are different from regular Windows laptops and you can't install Windows apps on them. However, there is a way you can run Microsoft Office on Chromebooks for free.

Instructions for printing double-sided paper in Word, PDF, Excel for printers that support 2-sided and 1-sided printing

Instructions for printing double-sided paper in Word, PDF, Excel for printers that support 2-sided and 1-sided printing

The need to print double-sided paper is now much more popular. However, not all printers can support double-sided printing, or with printers that allow double-sided printing, how to do it?

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

Solving Microsoft Teams Joining Error: Meeting ID Not Found

Solving Microsoft Teams Joining Error: Meeting ID Not Found

Tired of the frustrating Microsoft Teams Joining Error: Meeting ID Not Found? Get step-by-step fixes to rejoin meetings fast. Updated with the latest Teams patches for seamless collaboration. Solve it now!

Troubleshooting Microsoft Teams Video Error Green Screen

Troubleshooting Microsoft Teams Video Error Green Screen

Struggling with Microsoft Teams "Video Error" green screen? Discover proven, step-by-step troubleshooting fixes for seamless video calls. Quick solutions inside!

How to Fix Microsoft Teams How Teams Works Tutorial Error

How to Fix Microsoft Teams How Teams Works Tutorial Error

Struggling with the Microsoft Teams "How Teams Works" Tutorial Error? Discover proven, step-by-step fixes to resolve it quickly. Clear cache, update, and more for seamless onboarding. Works on latest versions!

How to Fix Microsoft Teams Error Today on Windows 10

How to Fix Microsoft Teams Error Today on Windows 10

Tired of the frustrating Microsoft Teams "Error Today" on Windows 10? Discover proven, step-by-step fixes to resolve it quickly and restore smooth teamwork. No tech skills needed!

Troubleshooting Microsoft Teams Room Basic vs Pro Errors

Troubleshooting Microsoft Teams Room Basic vs Pro Errors

Struggling with Troubleshooting Microsoft Teams Room Basic vs Pro Errors? Get step-by-step fixes for common issues, comparisons, and pro tips to resolve connectivity, licensing, and setup problems fast in both versions.

How to Fix Microsoft Teams Screen Sharing Lag in 2026

How to Fix Microsoft Teams Screen Sharing Lag in 2026

Tired of Microsoft Teams screen sharing lag ruining your 2026 meetings? Get instant fixes for lag, freezes, and poor quality. Proven steps to optimize performance and share screens flawlessly. Boost productivity today!

Troubleshooting Microsoft Teams Installation Errors on macOS

Troubleshooting Microsoft Teams Installation Errors on macOS

Struggling with Microsoft Teams installation errors on macOS? This ultimate guide provides proven, step-by-step fixes for common issues like Gatekeeper blocks, permission errors, and download failures to get Teams running smoothly on your Mac. Updated with the latest solutions.

How to Create and Manage a Bot in Microsoft Teams (2026)

How to Create and Manage a Bot in Microsoft Teams (2026)

Master how to create and manage a bot in Microsoft Teams (2026) with this expert guide. From setup to advanced management, unlock productivity boosts using the latest Bot Framework and Azure tools.

Troubleshooting Microsoft Teams Remote Control Request Error

Troubleshooting Microsoft Teams Remote Control Request Error

Tired of Microsoft Teams "Remote Control" Request Error blocking your meetings? Follow our proven, step-by-step troubleshooting guide with the latest fixes to restore seamless remote control and boost productivity instantly.

How to Fix Microsoft Teams Planner Error: Tasks Not Loading

How to Fix Microsoft Teams Planner Error: Tasks Not Loading

Struggling with Microsoft Teams Planner error where tasks not loading? Discover step-by-step fixes for Microsoft Teams Planner Error: Tasks Not Loading. Quick solutions for instant relief in Teams Planner. Updated with latest troubleshooting tips.

Troubleshooting Microsoft Teams Version History Errors

Troubleshooting Microsoft Teams Version History Errors

Tired of Microsoft Teams version history errors disrupting your workflow? This step-by-step troubleshooting guide covers common issues, quick fixes, and pro tips to restore seamless file versioning in Teams. Updated with the latest solutions!

Solving Microsoft Teams Error 2400: Unable to Connect to Servers

Solving Microsoft Teams Error 2400: Unable to Connect to Servers

Tired of Microsoft Teams Error 2400 blocking your connection? Follow our proven, step-by-step fixes to solve "Unable to Connect to Servers" and get back to productive meetings fast.

Where is My Microsoft Teams Recording Saved? Find Your Files Fast

Where is My Microsoft Teams Recording Saved? Find Your Files Fast

Struggling to locate your Microsoft Teams recording? Discover exactly where Teams saves meeting files in OneDrive or SharePoint, plus quick steps to find and access them instantly. No more lost recordings!

How to Fix Microsoft Teams Error G Audio

How to Fix Microsoft Teams Error G Audio

Struggling with Microsoft Teams "Error G" audio? Discover step-by-step fixes for microphone and speaker issues. Quick, easy solutions to get back to seamless meetings without frustration. Works on Windows, Mac & more!

Fixing Microsoft Teams Vcruntime140.dll Missing Error

Fixing Microsoft Teams Vcruntime140.dll Missing Error

Tired of the frustrating Microsoft Teams Vcruntime140.dll missing error crashing your meetings? Discover proven, step-by-step fixes to resolve it fast and restore smooth teamwork. No tech skills needed!