ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   cannot insert page break (https://www.excelbanter.com/excel-discussion-misc-queries/58669-cannot-insert-page-break.html)

tsmanz

cannot insert page break
 
I have RMB - Reset All Page Breaks.
Then I select a ROW, RMB - Insert Page Break. They page break is not inserted.
I also tried to add a vertical/column page break with no luck.

I tried this from the pull down menus as well (Insert - Page Break).

Any idea what could be wrong?

Using Office Professional Edition 2003

Thanks,
Sean

LawrenceHG

cannot insert page break
 
Try checking your page setup. When I have this problem, it's usually because
I've forgotten I had set the "fit to page" feature. This feature is not
compatible with setting your own page breaks (which is understandable).

Set the page scaling to use "% of normal size".

"tsmanz" wrote:

I have RMB - Reset All Page Breaks.
Then I select a ROW, RMB - Insert Page Break. They page break is not inserted.
I also tried to add a vertical/column page break with no luck.

I tried this from the pull down menus as well (Insert - Page Break).

Any idea what could be wrong?

Using Office Professional Edition 2003

Thanks,
Sean


tsmanz

cannot insert page break
 
solved - thanks Lawrence.

"LawrenceHG" wrote:

Try checking your page setup. When I have this problem, it's usually because
I've forgotten I had set the "fit to page" feature. This feature is not
compatible with setting your own page breaks (which is understandable).

Set the page scaling to use "% of normal size".

"tsmanz" wrote:

I have RMB - Reset All Page Breaks.
Then I select a ROW, RMB - Insert Page Break. They page break is not inserted.
I also tried to add a vertical/column page break with no luck.

I tried this from the pull down menus as well (Insert - Page Break).

Any idea what could be wrong?

Using Office Professional Edition 2003

Thanks,
Sean



All times are GMT +1. The time now is 10:08 AM.

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