ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Unwanted page breaks (https://www.excelbanter.com/excel-discussion-misc-queries/79573-unwanted-page-breaks.html)

Grace

Unwanted page breaks
 
After I created a worksheet, I protected it. Subsequently, I returned,
unprotected it and inserted (at about line 10) new information that resulted
in and insertion of about 30 new lines. When I go to Page Break Preview I
notice that after inserting the new lines, the system paginates the balance
of the worksheet on every row. I end up with a worksheet that has over 300
pages instead of about 10!

What did I do wrong?



All times are GMT +1. The time now is 04:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com