Tip Printed from ExcelTip.com

---

Adding Continuous Page Numbers While Printing


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

• When printing from one sheet, enter a number in the First page number box in the Page tab of that sheet's Page Setup dialog box.
• When printing a report from a few sheets, manually enter a page number in the Custom Footer in the Header/Footer tab of each sheet's Page Setup dialog box.
• Enter the page number into a cell when printing a page in landscape layout while the page number is in portrait layout.
• Use the automatic option for continuous numbers when using Report Manager.