Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
W. Watson
 
Posts: n/a
Default 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   Report Post  
Chip Pearson
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find automatic page breaks Reason Excel Worksheet Functions 1 April 15th 05 06:03 AM
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 09:29 AM
excel page breaks - urgent help required Louisa Excel Worksheet Functions 2 February 14th 05 05:03 PM
How do I keep page breaks for each page in a sheet without the co. notexcellent Excel Discussion (Misc queries) 0 February 9th 05 07:53 PM
Page breaks don't show on screen and don't print separately. It i. Peter Excel Discussion (Misc queries) 1 November 29th 04 04:33 PM


All times are GMT +1. The time now is 12:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"