Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't move my page breaks in Page Break Preview | Excel Discussion (Misc queries) | |||
Coding for Page Break | Excel Discussion (Misc queries) | |||
Page numbering problem | Excel Discussion (Misc queries) | |||
Page Numbers | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) |