+ Reply to Thread
Results 1 to 20 of 20

Can not print a Workbook page

  1. #1
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Can not print a Workbook page

    I am sure I am doing something wrong. I printed this very same page in MS Word,but this is different.
    I highlighted the page then set page but it only printed 3/4 of the page.
    Last edited by 420benz; 05-24-2012 at 06:25 PM.

  2. #2
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can not print a Workbook page

    Help please.

  3. #3
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can not print a Workbook page

    I think my post was written correctly,but no replies.??????

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Can not print a Workbook page

    Try going to your Print Area (Page Layout Tab) > Clear Print Area
    Did that help?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  5. #5
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can not print a Workbook page

    Quote Originally Posted by ChemistB View Post
    Try going to your Print Area (Page Layout Tab) > Clear Print Area
    Did that help?
    That did nothing.

  6. #6
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Can not print a Workbook page

    Is it possibly set to print on A4 paper or some other size paper? Can you upload the spreadsheet (replace any confidential data first)?

  7. #7
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can not print a Workbook page

    I will give it a try.

  8. #8
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can not print a Workbook page

    It only prints half of a page.

  9. #9
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Can not print a Workbook page

    Go to the View Tab and look at it under Page Layout and Page Break Preview and see if that offers any hints.

  10. #10
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can not print a Workbook page

    Page layout was checked. I unchecked it.Ribbon is checked.Now it spits out blank pages.In print preview is says 175 pages but it should only be two. This is driving me nuts.
    .

  11. #11
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can not print a Workbook page

    Is it possabile to Copy the page and paste it on to another? There must be a setting I am missing on this page.

  12. #12
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can not print a Workbook page

    Help Please.

  13. #13
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can not print a Workbook page

    Well I guess I will try to figure it out on my own. Thanks anyway.

  14. #14
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Can not print a Workbook page

    try to copy, let's say Sheet1 'n Sheet2 (the Sheets you want to print out) in a new Workbook and send it for printing or upload a test file with yr issue and maybe someone see a solution for you!
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  15. #15
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can not print a Workbook page

    Quote Originally Posted by john55 View Post
    try to copy, let's say Sheet1 'n Sheet2 (the Sheets you want to print out) in a new Workbook and send it for printing or upload a test file with yr issue and maybe someone see a solution for you!
    I tried copy paste to another sheet but that does not work.All I need to know is what the default settings should be on any workbook page.

  16. #16
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can not print a Workbook page

    Problem solved. The problem was that blue vertical dotted line that must be set to the right past the printable page.
    It does not show up until I start to print??????.

  17. #17
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can not print a Workbook page

    Can I assume that that blue dotted line is a margin that must be set every time I print or can I set it permenintly.

  18. #18
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can not print a Workbook page

    Sorry to be such a pain,but I tried to print the same pages today and now the printer prints blank pages.Whet the hell am I doing wrong?

  19. #19
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Can not print a Workbook page

    I'm thinking your "blue dotted line is a page break. When you go to View>"Page Break Preview", is your text in the grid area or in the gray area? Can you grab the dark blue line in that view and drag them outside your text area?

  20. #20
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Can not print a Workbook page

    Going back to the pasting in a new sheet. Try paste special > formulas (if you have formulas)
    or paste special > Values (if you don't have formulas)

+ 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