Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Page Breaks Run Amok!!
I'm using Excel 2003 -- or, rather, it's using me. Somehow there is now a
page break inserted *after every row,* turning my 3-page document into a 74-page document. I have followed the on-line Help instructions repeatedly (i.e., from within Page Break Preview, put cursor in an area outside the document, right-click, and select Reset All Page Breaks) but nothing changes. How do I remove the 70+ page breaks at once? I noticed someone posted a similar question in March, but received no answer. Time to lob some dynamite at the screen?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Page Breaks Run Amok!!
Hi Wendy, I've come across this problem a few months ago & the best information/suggestions I could find was that differing network printers can be incompatible/have driver problems when changed & that this could upset the Excel's page breaks. As painful as it may be, if you are working in multiple files/changing printers repeatedly (or at all?), the best solution was to choose the right printer, close all the files and then close Excel right down before reopening it and trying again. The above is assuming that you have already explored the options of changing the scale of the printable document &/or the paper size in the Print dialog box. hth Rob -- broro183 Rob Brockett. Always learning & the best way to learn is to experience... ------------------------------------------------------------------------ broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98647 |
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) | |||
Different Page Numbers In Worksheet w/Page Breaks | Excel Discussion (Misc queries) | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
Page Breaks- Printing selected rows on same page | Excel Discussion (Misc queries) | |||
How do I keep page breaks for each page in a sheet without the co. | Excel Discussion (Misc queries) |