Why does EXCEL insert bace breaks on every cell of some worksheets

M

Mr Chips

On some old worksheets, EXCEL is setting page breaks at every cell.
Specifying a smaller group of cells as the print area restores the desired
single page, but dragging the page break over or down one more cell causes
the breaks to appear at every cell ans a message that the margin doesen't
fit.
It seems that the page size is suddenly reduced to less than 1inch x 1 inch.
Resetting the margins to .05 allows the page to be displayed, but adding a
row or column again trips back to one cellper page?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top