Page Break Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger Fink - 23 Oct 2007 21:30 GMT

I have one particular Excel file that I can't get to accept horizontal or
vertical page breaks. When properly highlighted, the drop down Insert menu
will indicate a page break is installed at a particular column or row
("Remove Page Break"), but the break doesn't appear in Page Break Preview,
also Print Preview shows the whole file on one sheet. One possibility may be
that the file is pretty long horizontally, ending at column CA, by 70 rows
high. On the other hand I have another spreadsheet 160 rows high and never
had a problem, so maybe length/width is not the problem.

Is this a known bug in Excel 97? If so, is there a way to fix it?

Running fully patched Excel 97 on W2K Pro.

Reply to this Message

Dave Peterson - 23 Oct 2007 22:05 GMT

I haven't used xl97 in quite a while, but when you do File|Page setup, what do
you see on the Page tab?

Do you have "Adjust to..." or "Fit to..." checked?

If you have "fit to..." checked, then I think excel will use that setting--no
matter what you've done with page breaks.

> I have one particular Excel file that I can't get to accept horizontal or
> vertical page breaks. When properly highlighted, the drop down Insert menu
[quoted text clipped - 8 lines]
>
> Running fully patched Excel 97 on W2K Pro.

Signature

Dave Peterson

Reply to this Message

Roger Fink - 23 Oct 2007 22:27 GMT

Yes, that was it exactly. Thanks very much.

> I haven't used xl97 in quite a while, but when you do File|Page
> setup, what do you see on the Page tab?
[quoted text clipped - 17 lines]
>>
>> Running fully patched Excel 97 on W2K Pro.

Reply to this Message

Rate this thread: