Blog Archive

Printing page numbers on Excel Sheets

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.
Source:TeachExcel