If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
My worksheet prints blank, except for the header. How fix this?
When I try to print out my Excel worksheet, the page prints out blank except
for the header. How can I fix this? Does this mean the cells are all hidden, somehow, and I just need to unhide them? How would I unhide them if that's the problem? |
#2
|
|||
|
|||
My worksheet prints blank, except for the header. How fix this?
If rows and columns are hidden, you would see "missing" rows or columns, for example you would see A, B, C then it would jump to F, G, H or 1, 2, 3 and jumps to 7, 8, 9... My guess is that the print area was set up somehow, try to clear it. Go to File, Print Area, Clear Print Area Hope that helps -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=549991 |
#3
|
|||
|
|||
My worksheet prints blank, except for the header. How fix this?
If you can see the cells on the screen, they are not hidden. Could be a
number of things though. You could have set a print range, which has now become a blank area on your sheet? what happens when you do a Print Preview? What does it look like when you go into Page Break view? Do you select a range to print, and do you then click the Selection option? "lit" wrote: When I try to print out my Excel worksheet, the page prints out blank except for the header. How can I fix this? Does this mean the cells are all hidden, somehow, and I just need to unhide them? How would I unhide them if that's the problem? |
#4
|
|||
|
|||
My worksheet prints blank, except for the header. How fix this
Hey,
I am suffering the same problem, The print preview is normal but when you print it comes out blank. Will try to clear print area. Thanks, Brett |
#5
|
|||
|
|||
My worksheet prints blank, except for the header. How fix this
I'm not sure if excel really sees much of a difference between printing and
print previewing. I think I'd try a new printer/printer driver. Or even check the ink levels???? Brett wrote: Hey, I am suffering the same problem, The print preview is normal but when you print it comes out blank. Will try to clear print area. Thanks, Brett -- Dave Peterson |
#6
|
|||
|
|||
My worksheet prints blank, except for the header. How fix this
Thanks,
I've tried on three lazer and 2 bubblejet printers. I will get back to you all on the 23rd-24th of August when the user gets back from leave. Cya, Brett "Dave Peterson" wrote: I'm not sure if excel really sees much of a difference between printing and print previewing. I think I'd try a new printer/printer driver. Or even check the ink levels???? Brett wrote: Hey, I am suffering the same problem, The print preview is normal but when you print it comes out blank. Will try to clear print area. Thanks, Brett -- Dave Peterson |
#7
|
|||
|
|||
My worksheet prints blank, except for the header. How fix this?
I am having the same problem. I have tried to clear the print area, but it
doesn't seem to do anything. In the "Page Break Preview" mode, page 1 is at the top but then after the header page 4 is displayed and I can not seem to move the page break line inbetween them to show pages 2 and 3. In the print preview mode this comes up as page 1, 2 and 3 only having a header, and then the data starting on page 4 with a header. Is there a way to fix this so that I only have 1 page of printing, rather than 3 'blank' pages and then one page of data? "lit" wrote: When I try to print out my Excel worksheet, the page prints out blank except for the header. How can I fix this? Does this mean the cells are all hidden, somehow, and I just need to unhide them? How would I unhide them if that's the problem? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to include a variable in the header and/or footer of a worksheet | tmacke | General Discussion | 2 | April 14th, 2006 10:13 PM |
A Blank Page Follows the Report Header | David S | Setting Up & Running Reports | 2 | March 31st, 2006 02:28 AM |
Turn off Group header and turn on Page Header | Cat's Meow | Setting Up & Running Reports | 9 | January 12th, 2006 05:12 PM |
How do I setup a header in Excel that prints only on first page? | mikesam7 | General Discussion | 3 | August 24th, 2005 08:16 PM |
Header & Footer not on first page but on subsequent pages | KM1 | General Discussion | 14 | June 13th, 2005 12:36 AM |