+ Reply to Thread
Results 1 to 6 of 6

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

  1. #1
    lit
    Guest

    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. #2
    Forum Contributor
    Join Date
    06-01-2006
    Posts
    324
    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
    Google is your best friend!

  3. #3
    kassie
    Guest

    RE: 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. #4
    Brett
    Guest

    RE: 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. #5
    Dave Peterson
    Guest

    Re: 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. #6
    Brett
    Guest

    Re: 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
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1