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?

Answer: My worksheet prints blank, except for the header. How fix this?
 

It's possible that the cells in your worksheet are hidden or that the print area is not set correctly. Here are some steps you can take to fix this issue:

1. Check if the cells are hidden:
   - Select the entire worksheet by clicking on the box at the top left corner of the worksheet (above row 1 and to the left of column A).
   - Right-click on any of the selected cells and choose "Format Cells".
   - In the "Format Cells" dialog box, go to the "Protection" tab and make sure that the "Hidden" checkbox is unchecked. If it is checked, uncheck it and click "OK".
   - If this doesn't work, try selecting the cells that you want to unhide, right-clicking on them, and choosing "Unhide".
   
2. Check the print area:
   - Go to the "Page Layout" tab and click on "Print Area".
   - Make sure that the "Set Print Area" option is selected. If it's not, click on it to set the print area.
   - If the print area is set correctly, try adjusting the margins by going to the "Page Layout" tab and clicking on "Margins". Make sure that the margins are set to a reasonable size (e.g. 0.5 inches) and that the "Center on Page" option is unchecked.
   
3. Check the print preview:
   - Go to the "File" tab and click on "Print".
   - In the print preview window, make sure that the "Print Active Sheets" option is selected.
   - If the preview shows that the cells are still hidden, try selecting the entire worksheet and going to the "Home" tab. Click on the "Format" dropdown and choose "Hide & Unhide". Then, select "Unhide Rows" or "Unhide Columns" to unhide any hidden cells.

Hopefully, one of these steps will help you fix the issue and print your worksheet successfully.

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

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?

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

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

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

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?