How to Fix Part or Full Excel Spreadsheet Page Not Printing

Updated on April 29, 2016

Introduction

I received an Excel spreadsheet via email from a colleague, and I added two rows of data at the bottom of the page. I went to print the spreadsheet, but the whole page would not print out. Everything would print, except the two rows that I added.

There are a couple obvious options to fix this, but none was working. I tried "Page Set Up" and tried the "Adjust To" % settings, but that did not work. Since I only needed to print one page, I then tried the "Fit into 1 Pages Wide by 1 Pages Tall" and that didn't work either. For the life of me, I could not capture and print out the data I wanted. I also tried highlighting the entire spreadsheet area and then checking "Print Preview," but that didn't do squat either.

Here is the solution that ultimately wound up working for me. Hopefully, this applies to your problem as well.

As I do so often, please accept my apologies for the rough screen pics (I'll get better at it someday :-)

Step 1

Open your Excel Spreadsheet. You may want to try the solutions I described in the third paragraph in the introduction. If those doesn't work, continue to the next step.

Step 2

Look to the top right portion of your PC screen.


Click on "View."

Step 3

Then, look to the left side of your screen. Just to the right of the words "Page Layout," you'll see "Page Break Preview."

Click on "Page Break Preview."

If you don't see "Page Break Preview," you're probably seeing three tiny icons next to "Page Layout."

Click the top icon that is just to the right of "Page Layout" and "Page Break Preview" will appear..

Step 4

The screen will change, and your spreadsheet page will appear smaller. You will see a blue border around your spreadsheet.

The blue border defines the region that will be printed. You might notice that the cell data that's not printing is outside of this region.

You will want to expand this area so that the area that's not printing, falls within the blue boundary.

Position your cursor over the blue line that you want to expand. If your printer is missing cell data at the bottom of the page, position the cursor over the blue line at the bottom of the page. If you were missing data at the side, place your cursor to the blue line on the side. Your cursor will turn into an arrow that points in two directions.

Step 5

Then, drag the line so that the area that is not printing now falls within the boundaries of the blue line.

Step 6

Then go ahead and print as you normally would. The entire spreadsheet should come off the printer just as you hoped :-). I did a video on this below also just in case you're having a bit of trouble.

Here's a Video I Did Showing You What You Just Read

This article is accurate and true to the best of the author’s knowledge. Content is for informational or entertainment purposes only and does not substitute for personal counsel or professional advice in business, financial, legal, or technical matters.

Comments

    0 of 8192 characters used
    Post Comment
    • profile image

      Lillian 

      6 days ago

      Thank you!

    • profile image

      Peter 

      3 weeks ago

      Thank you , I was driving myself silly over why my Excel sheet 2 would print page 1&2 , But my Sheet 1 would only print page 1 and not print page 2 . Your “Page Break“ guide sorted out my issue.

    • profile image

      Josh 

      3 weeks ago

      Top man thank you!

    • profile image

      Ana 

      6 weeks ago

      Thank you so much. I was desperately looking for a solution for this exact problem and after an hours search came across this. Perfect!

    • profile image

      HUGO 

      4 months ago

      THANKS, GOOD JOB

    • profile image

      Debbie Treadwell 

      4 months ago

      Love it - a perfect solution! Thanks for sharing.

    • profile image

      Wert 

      5 months ago

      Yay it worked

    • profile image

      tgreer 

      5 months ago

      You are a genius! Thank you!!

    • profile image

      Tanner 

      6 months ago

      You're a god, thank you

    • profile image

      Nathan 

      6 months ago

      Outstanding, thanks so much

    • profile image

      Diana 

      8 months ago

      Thank-you, such a time saver!

    • profile image

      Daniel 

      9 months ago

      Thank you, thank you, thank you! This has plagued me for a long time!

    • profile image

      Sami 

      9 months ago

      thank you so much , I been trying so hard

      you solve it

      BR

    • profile image

      Jannette 

      10 months ago

      Omg thanks so much. It did work

    • profile image

      LEKAN 

      11 months ago

      Thanks a million. It helped.

    • profile image

      Erick 

      11 months ago

      thanks a myriad

    • profile image

      KP 

      11 months ago

      ACE!! Stuck on this for about an hour, great help.

    • profile image

      Glenn 

      12 months ago

      Awesome! Thanks...

    • profile image

      Shelley 

      12 months ago

      Thank you! That helped.

    • profile image

      Jenn 

      13 months ago

      Thanks, this really helped

    • profile image

      Duane 

      13 months ago

      Thank you so much

    • profile image

      Agua 

      14 months ago

      yes it worked

    • profile image

      Edwin 

      14 months ago

      so helpful. thanks

    • profile image

      Ash 

      16 months ago

      Thank you! Much appreciated.

    • profile image

      YUSUPH JOHN 

      17 months ago

      worked, thanks for sharing

    • profile image

      Cara199 

      17 months ago

      Thank you!

    • profile image

      Marko 

      18 months ago

      It works. Thank you!!!!

    • profile image

      Sarah 

      18 months ago

      wonderful.. It really worked! Thanks

    • profile image

      vivek 

      18 months ago

      but the problem is in my MS Excel I am unable to drag that dotted blue lines

    • profile image

      Jim 

      19 months ago

      Thank you!

    • profile image

      Sabina 

      19 months ago

      Thank you! You saved my day!

    • profile image

      Mario 

      20 months ago

      Thank you so much for posting this and helping me retain my sanity.

    • profile image

      Sheila 

      20 months ago

      Thank you! Worked like a charm!

    • profile image

      Galif Hasan 

      20 months ago

      Thanks a lot. 3

    • profile image

      karol Hall 

      21 months ago

      Thanks I had forgotten all about that formatting tool Been a while since I had to do any editing in excel

    • profile image

      zafar khan 

      21 months ago

      thanks a lots

    • profile image

      Margaret 

      21 months ago

      Thanks............worked perfectly.

    • profile image

      Ayman O.elfadil 

      21 months ago

      thanks for the info

    • profile image

      King 

      21 months ago

      This worked perfectly for me, thanks so much

    • profile image

      21 months ago

      Very helpful! Thank you!

    • profile image

      Karen 

      21 months ago

      Thank you!

    • profile image

      Bill Burns 

      21 months ago

      Well done, [Turtle]Dog! Thanks so much!

    • profile image

      Jan 

      22 months ago

      Very, very grateful (like so many others)!

    • profile image

      Melody 

      22 months ago

      Thanks you so very much for this. It really helped me. I had the same problem and it was doing my head in. Thanks again

    • profile image

      Nancy 

      22 months ago

      Thanks!!!

    • profile image

      Taqi Jaffer 

      22 months ago

      V. Good!

      My problem is resolved.

      Thanks.

    • profile image

      Brian 

      22 months ago

      Thanks - appreciate your solution

    • profile image

      Stephanie 

      22 months ago

      Thank you!!!

    • profile image

      Raul 

      23 months ago

      Thank you very much, was a great help

    • profile image

      Caro 

      23 months ago

      Thank you! Saved my life!

    • profile image

      Teresa Davis 

      23 months ago

      Thank you so much!!!

    • profile image

      Harry 

      23 months ago

      Thank you this worked for me.

    • profile image

      Judi 

      23 months ago

      Thank you so much for this! I added 7 new lines to a 3-page list, re-sorted alphabetically, and then the top seven lines wouldn't print any longer. I was truly flummoxed and increasingly frustrated. Your solution solved it!

    • profile image

      Beth Scott 

      23 months ago

      Thank you, thank you, thank you! This was driving me crazy, that my client list kept leaving off the last four names! I did not try all of the things that you did but your solution fixed it!

    • profile image

      Vicki 

      24 months ago

      Thank you thank you thank you!!!!

    • profile image

      Rizwan 

      2 years ago

      Thanks a lot

    • profile image

      Lawrence 

      2 years ago

      I am 85 years of age and while I was not quite around in the age of quill pens, I am certainly no computer guru. Nevertheless, I found a very simple solution to printing a one page spreadsheet. Having struggled with it for several days, it would either print over four pages or on one sheet but very small. My spreadsheet page was on Open Office so I went to select all and copy. I then pasted it into a text format instead of spreadsheet. It reproduced and printed perfectly and took about half a minute. Whether this would work on other types of spreadsheet I do not know but it solved my problem.

    • profile image

      karen 

      2 years ago

      yup!

    • profile image

      Brian 

      2 years ago

      Thanks so much, this worked perfectly.

    • profile image

      Jazz 

      2 years ago

      Thank you, love you.

    • profile image

      venkat1926@gmail.com 

      2 years ago

      my excel 2007 (windows 7) are configured to be entered dd-mm-yy. In this excel sheet I have set the print area including date column , but nothing is printed and print comes as blank. Then I changed the format of all the cells as BOLD . now all the data cells are printed EXCEPT DATE COLUMN. in the first preview date column cells are there. but when I click print button the date column is not printed.

    • profile image

      Joko 

      2 years ago

      Ooohhh... Thank You so much. This is really helpful for me this morning when starting my Monday.

    • profile image

      Bob M 

      2 years ago

      This has been driving me crazy. I've been using spreadsheets since CPM and Lotus123. I had a page break by column.

      Thanks.

    • profile image

      Thankful 

      2 years ago

      Ha. This worked! Thank you!

    • profile image

      glenn 

      2 years ago

      tried your suggestion for printing all of exel spreadsheet via view then page break preview then drag lines. my problem is half of the first column gets cut off even though I see entire document in preview. Unable to adjust the left border with the method you described. suggetions and thanks

    • profile image

      richr 

      2 years ago

      Just wanted to give a BIGS THANKS your solution worked perfectly.

    • profile image

      Laureen 

      2 years ago

      Thank you...your solution worked beautifully!

    • profile image

      JoeyAlpha5 

      2 years ago

      Awesome, This was extremely helpful

    • profile image

      Remie 

      2 years ago

      Thanks for the video

    • profile image

      JITENDRA RATH 

      2 years ago

      excel is not supported to print but word and every thing is printed. what can i do

    • profile image

      Casey 

      2 years ago

      Thank you for the help!!

    • profile image

      Kaui 

      2 years ago

      Thank you so much! Your solution worked wonders!

    • profile image

      Aimee 

      2 years ago

      Thank you so helpful

    • profile image

      Julianne 

      2 years ago

      Great solution but never required in prior Windows versions. Is there a way of eliminating this step for printing excel spreadsheets?

    • profile image

      lindsey 

      2 years ago

      thanks!

    • profile image

      Deborah Collins 

      2 years ago

      This worked perfectly. Thank you.

    • profile image

      James 

      2 years ago

      Just what i was looking for. Thanks for the helpful tip.

    • profile image

      Miss Willia,s 

      2 years ago

      thank you!!!!

    • profile image

      Bob Fenton 

      2 years ago

      your a genius... thanks...

    • profile image

      Priti Sumani 

      2 years ago

      Thanks.article solved my problem.

    • profile image

      Denise 

      2 years ago

      Great instructions, worked like a charm. Thank you

    • profile image

      New guy at firm 

      2 years ago

      Dude, this helped big time. Thank you!

    • profile image

      ED 

      2 years ago

      It works

    • profile image

      Kossi 

      2 years ago

      Awesome. Worked for me. Thanks for sharing

    • profile image

      Melanie 

      2 years ago

      Thanks so much! So useful. I was going crazy since I had tried all of the first solutions and none of them worked.

    • profile image

      Abhi 

      2 years ago

      Hello Sir

      thanks for posting this video, cheers...

    • profile image

      Mike 

      2 years ago

      Thank you soo Much! Easy step-by-step instructions!

    • profile image

      Alisa 

      2 years ago

      This was great- thank you! I never had to do the page break view thing before. Suddenly, I do. Oh well- so glad you bothered to post!

    • profile image

      Mo 

      2 years ago

      Thank you so much! That worked and solved my problem!!!

    • profile image

      Rachel 

      2 years ago

      Thank you, blessed genius - that saved my Friday afternoon!

    • profile image

      Dee 

      2 years ago

      Thank you, thank you!! This worked perfectly!

    • profile image

      Tianna 

      2 years ago

      I was breaking my head trying to figure out how to get this problem resolved and you explained it to the T! PERFECT

    • profile image

      Dave 

      2 years ago

      Thanks!!! Helped greatly !!!!

    • profile image

      Yeah! 

      2 years ago

      Thanks! Really solve my problem.

    • profile image

      Melinda 

      2 years ago

      I see the blue area but in the title it's green so it's still not printing the entire spreadsheet

    • profile image

      Sdu 

      2 years ago

      Wow, thanks a lot. Easy steps to follow. Problem solved!

    • profile image

      Ritvik 

      2 years ago

      That's okay. I am not facing any problem with rows, but with columns. How do I include an extra column that's going into Page 2 even though there is enough space on Page 1?

    • profile image

      Yogesh 

      2 years ago

      gr8 help...thanks

    • profile image

      G J 

      2 years ago

      Thanks for posting this! My work colleague wants to thank you too for providing this awesome solution!

    • profile image

      Eroca 

      2 years ago

      In my case, the heading printed but nothing underneath. I had inadvertently created the problem by selecting an incorrect setting on the Sheet Wanting my heading to print on each page, I had intended to click Rows to Repeat on each page but accidentally clicked Print Area (which was a few rows ahead on the Sheet option. So only the heading ever printed. Ah, well. live and learn.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, turbofuture.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://turbofuture.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)
    ClickscoThis is a data management platform studying reader behavior (Privacy Policy)