Print Page Numbers on Excel Worksheets

Add to Favorites
Author:

How to print page numbers with your spreadsheet.

Sections:

Steps

Add "Page # of [Total Pages]"

Add Custom Text

Notes

Steps

Go to the View tab and click Page Layout on the left of the Ribbon Menu.

e2173ea8cc36079916a6e086e32411ee.jpg

Click one of the 3 sections of the header or scroll down and click one of the 3 sections of the footer. (Each section is for spatial reference and allows you to put data on the left, right, or in the middle of the header/footer.)

e481195201dda7aeba6edf95ac4f393b.jpg

Or footer:

802eb098bc49ebe2be1d79d3c3383e53.jpg

On the Design tab that should have appeared, click Page Number.

8495213c5ffc687a1b6e9d3928633ee5.jpg

Once you click away from the header/footer, you will see the result:

96b812a8933902259f9a8bb30e44cae6.jpg

You can add more text around the numbers; look to the next sections for more information.

Add "Page # of [Total Pages]"

This format is: Page 1 of 2

Go to the View tab and click Page Layout and click a section in the header or footer and then, on the Design tab, click the Header option on the left and choose the 3rd option from the top.

fd556967d956a09a0b05e31c6733050b.jpg

It will automatically put the result into the middle section for you.

5c2362a58178f05d16338d9b299838a3.jpg

Move the Text out of the Middle

To move it out of the middle, just click in the middle, select the data that appears, cut it, and paste it onto one of the sides.

93de88f1dfa620a9fa4962992abd7b1c.jpg

3ef9347fcfa5350a37df44c17fb391d4.jpg

Add Custom Text

In the last examples you may have noticed that the text that appears is different from what goes into the header/footer when you edit it.

A sort of mini-language is used for printing and this allows us to add normal text around it.

Go to the header and type This is page and a space and then click the Page Number button, another space, and then type of and another space, and finally, click the Number of Pages button. It will look like this:

This is page &[Page] of &[Pages]

add16b3f20380f165072363e103948c3.jpg

Result:

96ce1bca977a4fe0723ad11788de97c5.jpg

You can put basically any text you want. The special elements start with an ampersand & and have square brackets around them.

By going to the Design tab for the header/footer, you can see options for the data that you can input in the Header & Footer Elements section. Also, by clicking the Header or Footer buttons on the left of the ribbon menu, you will see many pre-made options that can be useful and save a bit of time.

Notes

Working with headers and footers is a very important feature to make more professional looking spreadsheets when they are printed.

Make sure to download the sample file for this tutorial to work with these examples in Excel.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Insert and Manage Page Breaks in Excel
Tutorial: How to insert, remove, and manage page breaks in Excel.  This can be rather annoying and...
Remove Print Preview Lines in Excel
Tutorial: Here's how to remove the little dotted lines that sometimes appear on the spreadsheet. S...
Print Specific Pages in Excel
Macro: This free Excel macro allows you to print a pre-specified selection of pages from Excel. T...
Print Only Specific Parts of a Worksheet in Excel
Tutorial: In Excel you can select parts of a worksheet to print while ignoring all of the other data...
Scale Data for Printing in Excel - Fit more onto a Printed Page
Tutorial: This tip shows you how to fit more Excel data onto a page for printing. This does not chan...
Print Preview Display for Specific Worksheets in Excel
Macro: This free Excel macro allows you to display the print preview mode or window in Excel for ...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course