Continuing Headers
 

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?

Continuing Headers
 

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.

"Gr8 Dane" wrote:

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?

Continuing Headers
 

In the footer type:
&[Page]+51

Click "Yes" if it helps

"Gr8 Dane" wrote:

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?