Page Numbers

Tips, Tricks, and Answers

The following articles are available for the 'Page Numbers' topic. Click the article's title (shown in bold) to see the associated article.

Adding Page Numbers
How to add page numbers to a custom header or footer in an Excel worksheet.

Changing Page Number Format
Do you need a way to print something besides just Arabic numerals for your page numbers? Excel doesn't provide a way to perform that task, but you can create a quick macro that will produce the desired results.

Changing the Starting Page Number
Using page setup to change the starting page number of an Excel worksheet.

Figuring Out a Page Number
An easy method for finding out which page a particular cell will print on in Excel.

Page Numbers in VBA
When you print a larger worksheet, Excel breaks the printout across several pages. You may want to know, before you print, which page a particular cell will print on. There is no intrinsic function that delivers this information to you, but you can develop a macro that should provide just what you are looking for.

Roman Numerals for Page Numbers
Add page numbers to a worksheet, and they print out as Arabic numerals. If you want to use Roman numerals instead, you'll want to use the techniques described in this tip.