Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
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
Printing more than a single page? You may want to add page numbers to your printout, as discussed in this tip.
Changing Page Number Format
Need your page numbers to not appear as regular Arabic numerals? Here's a way to get them to appear in a different way—in this case in alphabetic order.
Changing the Starting Page Number
Got page numbers in your worksheet printout? You may want to have those page numbers start with a number other than 1. Here's how.
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
Yes, Excel can work with Roman numerals, and it even provides a worksheet function that converts to them. How you use those Roman numerals as page numbers on a printout is not nearly as easy, however.
Sequential Page Numbers Across Worksheets
How do you want your page numbers to appear on your printed worksheets? Chances are good that you want them to be sequential, regardless of what you print. Here's how to make sure that the page numbers are, in fact, in sequential order.