How to Fix Part or Full Excel Spreadsheet Page Not Printing

Updated on April 29, 2016


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


    0 of 8192 characters used
    Post Comment

    • profile image

      Brian 58 minutes ago

      Thanks - appreciate your solution

    • profile image

      Stephanie 5 hours ago

      Thank you!!!

    • profile image

      Raul 4 days ago

      Thank you very much, was a great help

    • profile image

      Caro 4 days ago

      Thank you! Saved my life!

    • profile image

      Teresa Davis 5 days ago

      Thank you so much!!!

    • profile image

      Harry 7 days ago

      Thank you this worked for me.

    • profile image

      Judi 2 weeks 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 3 weeks 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 6 weeks ago

      Thank you thank you thank you!!!!

    • profile image

      Rizwan 6 weeks ago

      Thanks a lot

    • profile image

      Lawrence 6 weeks 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 6 weeks ago


    • profile image

      jroberts 7 weeks ago

      Thank you!!!!!!!!!!!!!!!!!!!!!

    • profile image

      Brian 7 weeks ago

      Thanks so much, this worked perfectly.

    • profile image

      Jazz 2 months ago

      Thank you, love you.

    • profile image 2 months 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 months ago

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

    • profile image

      Bob M 2 months ago

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


    • profile image

      Thankful 2 months ago

      Ha. This worked! Thank you!

    • profile image

      glenn 2 months 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 3 months ago

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

    • profile image

      Laureen 3 months ago

      Thank you...your solution worked beautifully!

    • profile image

      JoeyAlpha5 3 months ago

      Awesome, This was extremely helpful

    • profile image

      Remie 4 months ago

      Thanks for the video

    • profile image

      JITENDRA RATH 4 months ago

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

    • profile image

      Casey 4 months ago

      Thank you for the help!!

    • profile image

      Kaui 4 months ago

      Thank you so much! Your solution worked wonders!

    • profile image

      Aimee 5 months ago

      Thank you so helpful

    • profile image

      Julianne 5 months 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 5 months ago


    • profile image

      Deborah Collins 5 months ago

      This worked perfectly. Thank you.

    • profile image

      James 5 months ago

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

    • profile image

      Miss Willia,s 5 months ago

      thank you!!!!

    • profile image

      Bob Fenton 7 months ago

      your a genius... thanks...

    • profile image

      Priti Sumani 7 months ago

      Thanks.article solved my problem.

    • profile image

      Denise 7 months ago

      Great instructions, worked like a charm. Thank you

    • profile image

      New guy at firm 7 months ago

      Dude, this helped big time. Thank you!

    • profile image

      ED 8 months ago

      It works

    • profile image

      Kossi 8 months ago

      Awesome. Worked for me. Thanks for sharing

    • profile image

      Melanie 8 months 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 9 months ago

      Hello Sir

      thanks for posting this video, cheers...

    • profile image

      Mike 9 months ago

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

    • profile image

      Alisa 9 months 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 11 months ago

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

    • profile image

      Rachel 11 months ago

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

    • profile image

      Dee 11 months ago

      Thank you, thank you!! This worked perfectly!

    • profile image

      Tianna 11 months 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 11 months ago

      Thanks!!! Helped greatly !!!!

    • profile image

      Yeah! 11 months ago

      Thanks! Really solve my problem.

    • profile image

      Melinda 12 months 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 12 months ago

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

    • profile image

      Ritvik 12 months 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 12 months ago

      gr8 help...thanks

    • profile image

      G J 12 months ago

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

    • profile image

      Eroca 12 months 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.

    • profile image

      Chris Perry 13 months ago

      Thank you for your help! I appreciate people that post this type of info because we all run into weird tech issues! Thanks again to you!

    • profile image

      John 13 months ago

      Thank you so much!! I was going crazy with this issue

    • profile image

      Jessica 13 months ago

      Thank you so much! I wasted much time on this today and you've solved the problem in 2 minutes of reading.

    • profile image

      A. kulkarni 14 months ago

      thank u so much it was very helpful

    • profile image

      Melanie 14 months ago

      Ditto - Finally a solution to this very aggravating issue! Thank you!!!!!

    • profile image

      Joe 14 months ago

      This worked perfectly per your step by step instructions. Thank you so much!

    • profile image

      Stefan 14 months ago

      thanks, worked perfectly. Excel is driving my crazy sometimes

    • profile image

      POCallaghan 14 months ago

      Thank you, this worked perfectly. Learnt something new today.

    • profile image

      Byron 15 months ago

      thanks for teaching me

    • profile image

      Joanne 15 months ago

      I just stopped hitting my head against the wall. Thank you thank you.

    • profile image

      Alex 15 months ago

      THANK YOU! It was driving me mad, but that was it!

    • profile image

      Sheryl 15 months ago

      Thank you! I've been looking everywhere for a solution. although it didn't work exactly the same for me (moving the blue lines didn't solve the problem) it gave me a way to solve it. I was able to manually expand each row (nearly every cell was being cut off, not just the last on the page) by simply pulling the line down at the left row marker (hope this makes sense). When I did this in other views it didn't change printing, but when I did this in page view, it worked. You're the best. Keep blogging!

    • profile image

      Robin 15 months ago

      So helpful thank you!!!!

    • profile image

      Diane 15 months ago

      Thank you!!! Well written and successful fix!

    • profile image

      Richard 16 months ago

      thanks !!!!!!!!!!!!!!!!!!!!!!!!

    • profile image

      Trish 16 months ago

      You saved me!

    • profile image

      Gayle 16 months ago

      Thank you so much for this, I had to add some required information to an invoice and every time I exported to PDF the new information was missing.

      Now fixed thanks to your instructions!

    • profile image

      Orla 16 months ago

      Cool, I was so confused, thanks so much for the help!

    • profile image

      Gloria 16 months ago

      Thanks so much. I could follow the directions and it worked.

    • profile image

      Gabi 16 months ago

      Brilliant, thank you!!! I thought I was losing my mind, couldn't for the life of me figure out what was going on.

    • profile image

      John C 16 months ago

      I was struggling with this one off issue all day today and all my breaks and such are done grammatically. I followed your advice and moved the break manually, then moved it back to it's original place and now it works! Thanks!

    • profile image

      KSU 17 months ago

      Thank you

    • profile image

      LASAuckland 17 months ago

      Brilliant thank you. This was driving me nuts.

    • profile image

      Danny 17 months ago

      OMG i had the same problem i could not figure it out for the life of me. THANK YOU soooooo much

    • profile image

      wass 18 months ago

      you are a hero man :)

    • profile image

      Andrew 18 months ago

      Saved me a lot of time. Been playing with it off and on for a while and this worked!

    • profile image

      Becky 19 months ago

      Thank you--I've been trying to fix this for 30 minutes!

    • profile image

      Joel 19 months ago

      Alternative crappy solution: take a screenshot then ctrl-v in MS paint, crop it, then print.

    • profile image

      John 19 months ago

      VERY helpful...thanks!!

    • profile image

      Nicole 20 months ago

      Thank you so much! You just saved me at work!

    • Thief12 profile image

      Thief12 20 months ago from Puerto Rico

      You say it like it's a glitch :-D Obviously not every spreadsheet will have the exact same amount of columns, so there's no way for Microsoft programmers to establish a fixed set of columns to print.

    • profile image

      La 20 months ago

      Thank you!!!

    • profile image

      Shadi 20 months ago

      LMAO, you would figure that the blacked out cells would print on another page! Thank you for saving my sanity.

    • profile image

      Candice 20 months ago

      It worked! Thank you!

    • profile image

      Isaac 21 months ago

      Thank you!!!!

    • profile image

      Suzie 22 months ago

      After a lot of frustration, I came across this which fixed the problem. Thanks so much!

    • profile image

      Ryan 22 months ago

      Brilliant. *Thumbs up*

    • profile image

      Ambrosia 22 months ago

      Thank you so much!

    • profile image

      Bad_replay 22 months ago

      Simple Solution:

      -Go to "Page Layout" tab

      -Click on "Print Area"

      -Select "Clear Print Area"



    • profile image

      Dianna 22 months ago

      It worked!! Thank you ever so much!!

    • profile image

      CiCi 22 months ago

      Thanks. With Excel 2013 had a grayed out page, only on one of my two sheets! I had to right click on grayed area and re-set page. Voila~! The rest of my sheet reappeared.

    • profile image

      Didier 22 months ago

      This was driving me nuts at work. This really was a simple fix thank you!

    • profile image

      Rob 24 months ago

      Hey everyone, I found that going to file, print area and then delete print area (on a mac and in French so hope the translation makes sense :) the problem was solved as well.

    • profile image

      Becca 24 months ago

      THANK YOU! You just saved my butt!!! :o)

    • profile image

      2 years ago

      Thank you very much for this.