Part of or Whole Spreadsheet Page Not Printing on Excel - Fix Here

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 and 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 were working.  I tried "Page Set Up" and tried the "Adjust To" % settings and 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 and 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 :-)

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

Look to the top right portion of your PC screen.

Click on "View"

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 are not seeing "Page Break Preview" you probably see 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.

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 outside of this region is your cell data that is not printing.

You will want to expand this area so that the area that is not printed out 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 to the side, position your cursor to the blue line on the side.  Your cursor will turn into an arrow that prints in two directions.

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

Then go ahead and print as you normally would. The entire spreadsheet should come off the printer just as you hoped :-)