#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i carry a balance to next row without it continuing down? Modine Charts and Charting in Excel 0 June 19th 08 11:53 PM
Continuing Macro Jase4now Excel Discussion (Misc queries) 5 May 20th 08 07:50 PM
formulas continuing crtreporter Excel Worksheet Functions 1 April 13th 07 08:16 PM
set up a continuing roster? petemack Excel Discussion (Misc queries) 7 August 7th 05 08:14 PM
Continuing formulas jess New Users to Excel 1 May 20th 05 03:08 PM


All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"