Tip Printed from ExcelTip.com

---

Inserting Page Numbers in Excel 2007


Excel offers a number of options for printing continuous page numbers.

To Insert a Page Number using Page Setup dialog box:

1. Select Page Layout -> Click Dialog Box Launcher in the bottom-right corner
of Page Setup group -> Header/Footer tab -> Custom Footer.
2. Select a section, click Insert page Number command, and click OK.

To Insert Running Page Numbers when printing a report:

Use the automatic option for continuous numbers when using Report Manager.