Excel adding automatic page breaks to every cell

Question

When the document is complete, page layout is set to 1 page no page breaks present.  When I save as pdf it prints normally on one page.  If I go to print preview, try to print or save in excel it automatically inserts page breaks to every cell, columns/rows the entire document and tries to print every cell individually.  I've cleared out the page breaks after going into print preview then clicking print at the top of the document skipping print preview and still does it.  I have researched and tried so much, no luck so far.  I also ran repair on Office 2013 from control panel.

Answer 1

Hi,

Welcome to Microsoft Community.

First delete all the temp files. Page breaks can be manual or automatic.

The automatic ones are decided by Excel in conjunction with the printer driver.

I would suspect the printer driver is either faulty or has been set up with an inappropriate page size (look under Page Layour > Page Setup > Size) or with inappropriately large margins (look under Margins on the same tab).

Check these settings and this should fix the issue.

Hope this information helps you. Please let us know if you need additional information.

Thank you.

Answer 2

Update your printer driver to latest from internet.