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

How to Fix Microsoft Teams Call Failed Error in 2026

How to Fix Microsoft Teams Call Failed Error in 2026

Struggling with Microsoft Teams "Call Failed" error in 2026? Discover quick, proven fixes to get your calls working smoothly. Step-by-step guide with latest troubleshooting tips for seamless video and audio.

How to Fix Microsoft Teams Copilot Error AI Not Responding

How to Fix Microsoft Teams Copilot Error AI Not Responding

Struggling with Microsoft Teams Copilot Error where AI stops responding? Discover step-by-step fixes for Microsoft Teams "Copilot Error" AI Not Responding, from quick restarts to advanced troubleshooting. Get back to productivity fast!

Solving Microsoft Teams Password Error: Incorrect Credentials

Solving Microsoft Teams Password Error: Incorrect Credentials

Stuck with Microsoft Teams password error "Incorrect Credentials"? Discover quick, proven fixes to get back online fast. Step-by-step guide with latest solutions for seamless login. Solve it now!

How to Fix Microsoft Teams Y Error Configuration

How to Fix Microsoft Teams Y Error Configuration

Struggling with Microsoft Teams "Y Error" configuration issues? Discover proven, up-to-date fixes to resolve the error quickly and restore seamless teamwork. Step-by-step guide inside!

Troubleshooting Microsoft Teams Error Screenshot Not Saving

Troubleshooting Microsoft Teams Error Screenshot Not Saving

Struggling with Microsoft Teams "Error Screenshot" not saving? Discover quick, effective troubleshooting steps to resolve this frustrating issue and restore smooth functionality in your daily workflows.

How to Download Microsoft Teams Chat History and Transcripts

How to Download Microsoft Teams Chat History and Transcripts

Master how to download Microsoft Teams chat history and transcripts effortlessly. Step-by-step guide with proven methods for chats, meetings, and admin exports—no tech skills needed!

Solving Microsoft Teams Ringtone Not Working Error

Solving Microsoft Teams Ringtone Not Working Error

Tired of silent Microsoft Teams ringtone not working? Follow our expert, step-by-step guide with quick fixes and advanced troubleshooting to get notifications ringing again. No tech skills needed!

Troubleshooting Microsoft Teams Login Error on Chromebook

Troubleshooting Microsoft Teams Login Error on Chromebook

Stuck with Microsoft Teams login error on Chromebook? Our ultimate troubleshooting guide delivers quick, reliable fixes for cache issues, updates, and more. Resolve it in minutes and stay connected!

Solving Microsoft Teams Desktop Error Startup Crash

Solving Microsoft Teams Desktop Error Startup Crash

Tired of Microsoft Teams Desktop Error crashing on startup? Follow our proven, step-by-step fixes to resolve Teams startup crash instantly. Works on latest versions!

Why Cant I See Breakout Rooms in My Teams Meeting?

Why Cant I See Breakout Rooms in My Teams Meeting?

Frustrated because Breakout Rooms are missing in your Teams meeting? Uncover the top reasons why you can't see Breakout Rooms in Teams and follow our step-by-step fixes to get them working smoothly in minutes. Perfect for organizers and participants alike!

Solving Microsoft Teams Cho Mac Error (Mac OS)

Solving Microsoft Teams Cho Mac Error (Mac OS)

Tired of the frustrating Microsoft Teams "Cho Mac" error crashing your Mac OS workflow? Follow our proven, step-by-step fixes to solve Microsoft Teams "Cho Mac" Error (Mac OS) quickly and restore seamless team collaboration. Updated with latest patches.

Troubleshooting Microsoft Teams Guest Access Error

Troubleshooting Microsoft Teams Guest Access Error

Stuck with Microsoft Teams "Guest" access error? Follow our expert, step-by-step troubleshooting guide to resolve guest invite failures, permission issues, and more. Get guests collaborating in Teams today!

Step-by-Step: How to Make Breakout Rooms Before a Meeting Starts

Step-by-Step: How to Make Breakout Rooms Before a Meeting Starts

Unlock seamless collaboration with this ultimate step-by-step guide on how to make breakout rooms before a meeting starts in Zoom. Pre-assign participants effortlessly for maximum engagement. Perfect for educators, teams, and leaders.

How to Fix Microsoft Teams Down Server Status 2026

How to Fix Microsoft Teams Down Server Status 2026

Is Microsoft Teams down in 2026? Discover proven steps to fix "Down" server status, troubleshoot outages, and get back to seamless collaboration fast. Quick fixes inside!

Troubleshooting Microsoft Teams Error H Updates

Troubleshooting Microsoft Teams Error H Updates

Struggling with Microsoft Teams "Error H" during updates? Discover step-by-step troubleshooting for Microsoft Teams "Error H" updates, common causes, and quick fixes to restore seamless collaboration. Updated with the latest solutions.