Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i carry a balance to next row without it continuing down? | Charts and Charting in Excel | |||
Continuing Macro | Excel Discussion (Misc queries) | |||
formulas continuing | Excel Worksheet Functions | |||
set up a continuing roster? | Excel Discussion (Misc queries) | |||
Continuing formulas | New Users to Excel |