ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MS Office Excel97: Removing Page Breaks (https://www.excelbanter.com/excel-discussion-misc-queries/22239-ms-office-excel97-removing-page-breaks.html)

W. Watson

MS Office Excel97: Removing Page Breaks
 
How do I remove page breaks? For some unknown reason they started appearing on a
spreadsheet recently. I see dotted lines dividing up the sheet and large "Page
...." in the background. According to an Office 97 book I have, I should go to
Tools-Options-View-tab and set the Page Break option off. There isn't any. If
I right click outside the page area, I see PG menu items but none seem to work.
There's also a PB View in the View menu, but clicking on it doesn't seem to do
anything. Weird.
--
Wayne T. Watson (Watson Adventures, Prop., Nevada City, CA)
(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet

"Academic disputes are vicious because so little
is at stake." -- Anonymous

Web Page: <home.earthlink.net/~mtnviews


Chip Pearson

Ensure you're not in Page Break Preview mode. Go to the View menu
and choose Normal.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"W. Watson" wrote in message
ink.net...
How do I remove page breaks? For some unknown reason they
started appearing on a spreadsheet recently. I see dotted lines
dividing up the sheet and large "Page ..." in the background.
According to an Office 97 book I have, I should go to
Tools-Options-View-tab and set the Page Break option off.
There isn't any. If I right click outside the page area, I see
PG menu items but none seem to work. There's also a PB View in
the View menu, but clicking on it doesn't seem to do anything.
Weird.
--
Wayne T. Watson (Watson Adventures, Prop., Nevada
City, CA)
(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std.
time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700
feet

"Academic disputes are vicious because so
little
is at stake." -- Anonymous

Web Page:
<home.earthlink.net/~mtnviews




Gord Dibben

Wrong place.

On main menu bar(File, Edit, View etc.)

ViewNormal


Gord Dibben Excel MVP

On Fri, 15 Apr 2005 20:35:59 GMT, "W. Watson" wrote:

Tools-Options-View-tab and set the Page Break option off.




All times are GMT +1. The time now is 02:51 AM.

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