Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find automatic page breaks | Excel Worksheet Functions | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
excel page breaks - urgent help required | Excel Worksheet Functions | |||
How do I keep page breaks for each page in a sheet without the co. | Excel Discussion (Misc queries) | |||
Page breaks don't show on screen and don't print separately. It i. | Excel Discussion (Misc queries) |