Excel.Tips.Net ExcelTips (Menu Interface)

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
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.


Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2017 Sharon Parq Associates, Inc.