Continuing Headers

[Gr8 Dane]

After completing a spreadsheet in Excel 2003, I was only able to make 50
pages (Landscape format) before I could not create more. I was going to
continue above page 50, to the next colums to the right, however different
line spacing prevents that. I had to Open a new spreadsheet and continue from
there. My question is: How do I get the New spreadsheet footer (page number)
to continue on starting at "pg 51" instead of "pg 1" again?

 

[Gr8 Dane]

Just wanted you all to know I figured it out. I was finally able to put the
two separate files into 1 workbook, with 2 sheets, then I right-cilcked on
the Sheet page, Select All Sheets, and then created my footer "Page ? of ?".
This linked both sheets into one continuous link of, currently, 1 of 70..
instead of 1 of 50, and 1 of 20.

 

[Khoshravan]

In the footer type:
&[Page]+51

Click "Yes" if it helps