page break in Excel 97

J

JD

I have to use Excel 97 for a project I am working on. When I insert a page
break into the spreadsheet nothing happens. It is as though the inserted
page break does not exist. I am able to "Remove" the page break - even
though there is not really a page break.

Any ideas on why the page break function will not work? I have already gone
to Tools->Options and selected Page Breaks.

Thank you!
 
J

Jim Cone

Page breaks will not appear on the worksheet if fit to pages wide or
fit to pages tall are set. The page breaks are there but not visible.
Set Page scaling (zoom) in PageSetup to 100% if you want to view page breaks.
--
Jim Cone
Portland, Oregon USA



"JD" <[email protected]>
wrote in message
I have to use Excel 97 for a project I am working on. When I insert a page
break into the spreadsheet nothing happens. It is as though the inserted
page break does not exist. I am able to "Remove" the page break - even
though there is not really a page break.
Any ideas on why the page break function will not work?
I have already gone to Tools->Options and selected Page Breaks.

Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cover Page - Use "Next Page Break" rather then Page Break 0
Use "Next Page Break" instead of "Page Break" on the cover page. 0
Section Breaks 0
Two columns followed by single page-width column on same page 0
Mail Merge Directory Conditional Page Break 0
Determine if previous "character" is a section break 3
Getting a page break to take 0
MS Word Page Layout/Break/Margin Issues, help 0

Top