Use the continuous page numbers technique in Report Manager in Microsoft Excel.

 

Problem
There is no way to set the first page number or to number additional pages (for example, a page added from the Word program) so that it will print in the report. The first page that is printed will be numbered 1.

Solution
Insert additional dummy’s Custom Views or Sheets into the report (for example, reinsert the Profit and Loss Statement view), and use the report with the correct number in the footer (you may destroy the extra pages with the incorrect numbers).

Note
You can use Report Manager to control automatic numbering if you change the default setting of First page number from Auto to a number.
From the File menu, select Page Setup, Page tab, and change First page number from Auto to any number.
Make this change in all the sheets you want to print



One thought on “Use the continuous page numbers technique in Report Manager in Microsoft Excel.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>