Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I know this isn't a function problem but I posted in the general Excel
section and got no response so I thought I would try here where I get answers quickly. This is what I posted: I'm sure this is something easy and I'll feel like a fool when I hear the answer but.... I have a spreadsheet with 26 worksheets in it and they have the page number set up in the footer. When I grab worksheets 1-26 and print preview/print, I can see 25 pages exactly as they should be with no problems but page 8 is completely blank. When I open the worksheet for page 8 the data is there. When I print preview that one page I see the page as it should be. Why when I grab it with outher worksheets does the data disapeer from view. I have tried re-defining the print section. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
JICDB wrote:
I know this isn't a function problem but I posted in the general Excel section and got no response so I thought I would try here where I get answers quickly. This is what I posted: I'm sure this is something easy and I'll feel like a fool when I hear the answer but.... I have a spreadsheet with 26 worksheets in it and they have the page number set up in the footer. When I grab worksheets 1-26 and print preview/print, I can see 25 pages exactly as they should be with no problems but page 8 is completely blank. When I open the worksheet for page 8 the data is there. When I print preview that one page I see the page as it should be. Why when I grab it with outher worksheets does the data disapeer from view. I have tried re-defining the print section. Just a wild guess. Look at worksheet 7 and change the View to Page Break Preview. Are there two pages indicated, the second one of which is blank? |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thank you so much. I knew was a basic thing I was completly overlooking.
Appreciate your help. "smartin" wrote: JICDB wrote: I know this isn't a function problem but I posted in the general Excel section and got no response so I thought I would try here where I get answers quickly. This is what I posted: I'm sure this is something easy and I'll feel like a fool when I hear the answer but.... I have a spreadsheet with 26 worksheets in it and they have the page number set up in the footer. When I grab worksheets 1-26 and print preview/print, I can see 25 pages exactly as they should be with no problems but page 8 is completely blank. When I open the worksheet for page 8 the data is there. When I print preview that one page I see the page as it should be. Why when I grab it with outher worksheets does the data disapeer from view. I have tried re-defining the print section. Just a wild guess. Look at worksheet 7 and change the View to Page Break Preview. Are there two pages indicated, the second one of which is blank? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print multiple copies of a spreadsheet on one page | Excel Discussion (Misc queries) | |||
Print Multiple Sheets to PDF Problem | Excel Discussion (Misc queries) | |||
print excel spreadsheet splitting cell contents on multiple pages | Excel Discussion (Misc queries) | |||
How do I print a spreadsheet with multiple worksheets? | Excel Discussion (Misc queries) | |||
How do I print a one page spreadsheet multiple time, each with its own page number? | Excel Discussion (Misc queries) |