Excel Online prints rows overlapping

Question

When I try to print a spreadsheet from Excel online, it cuts the bottom row on each page in half and the text in the row gets knocked down to the next page..... often overlapping the text in the beginning row on the next page.   It does this in the print preview and when the document is actually printed.  It does it with Google Chrome and with Internet Explorer.  It does it with any computer I print from and any printer I print to.  I have printed to a .pdf and it does the same.  I've changed the font type and size, adjusted the row heights, page breaks, text wrap, cell alignment..... and none of those helped.

If I open the document in the desktop version of Excel, it prints correctly.  But I need users to be able to print shared documents from the browser without having to open in the desktop version of Excel.

I'm attaching a picture of what happens. 

Answer 1

I'm still having this problem.  Anyone have any solutions?

Answer 2

Hi Mandy,

To further isolate the issue, please provide the details of the following:

1. What version of IE are you using?
2. Have you tried printing the document using a different computer?
3. Did you check the print preview before printing?

We'll be waiting for your response.

Regards.

Answer 3

As stated in my original question:

"It does this in the print preview and when the document is actually printed.  It does it with Google Chrome and with Internet Explorer.  It does it with any computer I print from and any printer I print to."

1. The version of IE is 11.  It does the same thing in Google Chrome also.
2.  I have tried printing from multiple computers and multiple printers.
3.  Print preview looks the same as it does when it prints.

Answer 4

It is possible that the issue is caused by an incorrect Page Orientation. When printing make sure to change the settings under Page Orientation, Margins, and Scaling.

If the issue persist, you can also try these steps as a workaround.

1. Highlight the area you want to print.
2. Press ctrl + P.
3. Select Current Selection.

Let us know how it goes.

Regards.

Answer 5

I have it on portrait orientation, which is what I want it to be.  I also tried landscape and it has the same problem.

I tried different scaling options and margins and they all have the same problem.

I tried printing a selected area and it has the same problem.