ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Page break problem (https://www.excelbanter.com/excel-discussion-misc-queries/114101-page-break-problem.html)

Dan DeCoursey

Page break problem
 
Hello,

I have a worksheet I select a row and do "insert page break" I see no
new page break even in pagebreak preview so you think there is no new
pagebreak established...... but I now see "remove pagebreak " on the
tool menu as if there is a new pagebreak......long story short I do not see
it

any ideas ?
thanks

[email protected]

Page break problem
 
One possibility is that, in the page setup dialog box, you've clicked
on "Fit x ___ pages wide by ___ pages tall". This makes all page
breaks ineffective, even though you can still insert and remove them

Hope this helps,
Dom



Dan DeCoursey wrote:
Hello,

I have a worksheet I select a row and do "insert page break" I see no
new page break even in pagebreak preview so you think there is no new
pagebreak established...... but I now see "remove pagebreak " on the
tool menu as if there is a new pagebreak......long story short I do not see
it

any ideas ?
thanks



jpreman

Page break problem
 
Hello Dan,

Try this. To see the page breaks, keep the worksheet in NORMAL view. Then in
the TOOLS menu select OPTIONS. Under OPTIONS select the tab VIEW and under
WINDOWS OPTIONS remove the the tick mark for "Gridlines". Now you would be
able to see where the page breaks are.

You would be able to remove the page breaks in the normal way.



"Dan DeCoursey" wrote:

Hello,

I have a worksheet I select a row and do "insert page break" I see no
new page break even in pagebreak preview so you think there is no new
pagebreak established...... but I now see "remove pagebreak " on the
tool menu as if there is a new pagebreak......long story short I do not see
it

any ideas ?
thanks


Dan DeCoursey

Page break problem
 
You were right on the money ..thanks a ton

" wrote:

One possibility is that, in the page setup dialog box, you've clicked
on "Fit x ___ pages wide by ___ pages tall". This makes all page
breaks ineffective, even though you can still insert and remove them

Hope this helps,
Dom



Dan DeCoursey wrote:
Hello,

I have a worksheet I select a row and do "insert page break" I see no
new page break even in pagebreak preview so you think there is no new
pagebreak established...... but I now see "remove pagebreak " on the
tool menu as if there is a new pagebreak......long story short I do not see
it

any ideas ?
thanks





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

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