+ Reply to Thread
Results 1 to 4 of 4

First Row of Document Will Not Print, But Header Prints

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    MN
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question First Row of Document Will Not Print, But Header Prints

    The first edit of the document printed perfectly; after adding one column during the second edit, the first row of the document will not print. It does not show in print preview either. The header prints, however, and shows in the print preview.

    This is a basic text-only 1 page document with no formulas.

    I did notice that when I tried to save it, this dialog box popped up:

    COMPATIBILITY CHECKER

    Summary: Minor loss of fidelitiy
    Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available.


    Thanks for any help or tips!

  2. #2
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    245

    Re: First Row of Document Will Not Print, But Header Prints

    In the lower right corner of the screen next to the magnification options, there are three different view types. Click page break preview (furtherst to the right of the three) and make sure the new row is within your print area. You can also try Page Layout -> Print Area -> Clear Print Area

  3. #3
    Registered User
    Join Date
    11-26-2012
    Location
    MN
    MS-Off Ver
    Excel 2007
    Posts
    2

    Cool Re: First Row of Document Will Not Print, But Header Prints

    Quote Originally Posted by zumbalj View Post
    In the lower right corner of the screen next to the magnification options, there are three different view types. Click page break preview (furtherst to the right of the three) and make sure the new row is within your print area. You can also try Page Layout -> Print Area -> Clear Print Area

    Page Break Preview is my default view, thanks

    Clear Print Area worked! Did not know about this function. Thank you for bringing it to my attention.

    What does 'Clear Print Area' do, exactly?

  4. #4
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    245

    Re: First Row of Document Will Not Print, But Header Prints

    It basically resets the print area to default settings from whatever it was previously set to. If this fixed your problem, please remember to mark your post as "SOLVED." Glad to help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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