Printing after using "Page Break View"

[John Newell]

For some reason, when I try to change the number of columns that will appear when I print using "Page Break View" I'm now getting only every single cell highlighted -- a mass of squares -- and only half the page is shown when I hit print. This has happened in the past, and I don't remember how it was corrected. What did I do wrong? Thanks

 

[Johnny Thunder]

Have you already set the Print Area?

Using the Ribbon ensure that the print area has been selected.

Then on Print Setup make sure you have the settings to Print Active Sheet and then the scaling (last setting) set to Print on how many sheets you need.