Tips, Tricks, and Answers

The following articles are available. 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Changing the Starting Page Number Using page setup to change the starting page number of an Excel worksheet. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Figuring Out a Page Number An easy method for finding out which page a particular cell will print on in Excel. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)