ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Page breaks won't budge (https://www.excelbanter.com/excel-discussion-misc-queries/176718-page-breaks-wont-budge.html)

ibvalentine

Page breaks won't budge
 
I am using Excel 2007 and for some reason there are several page breaks in
the worksheet. I cannot get rid of them. I cannot drag them off in Page Break
view and I don't see any other option where I can remove them. Does anyone
know how I can remove these stubborn page breaks. And also these page breaks
show up on every workbook that I open.

Jim Rech[_2_]

Page breaks won't budge
 
It sounds like you're seeing automatic page breaks. They are always there
but you can turn off their display under Excel Options.

--
Jim
"ibvalentine" wrote in message
...
|I am using Excel 2007 and for some reason there are several page breaks in
| the worksheet. I cannot get rid of them. I cannot drag them off in Page
Break
| view and I don't see any other option where I can remove them. Does anyone
| know how I can remove these stubborn page breaks. And also these page
breaks
| show up on every workbook that I open.



ibvalentine

Page breaks won't budge
 
No, they are page breaks that were entered by someone. When the page is
previewed in Print Preview, the worksheet is sliced into several small pages
only a few cells width and high.

"Jim Rech" wrote:

It sounds like you're seeing automatic page breaks. They are always there
but you can turn off their display under Excel Options.

--
Jim
"ibvalentine" wrote in message
...
|I am using Excel 2007 and for some reason there are several page breaks in
| the worksheet. I cannot get rid of them. I cannot drag them off in Page
Break
| view and I don't see any other option where I can remove them. Does anyone
| know how I can remove these stubborn page breaks. And also these page
breaks
| show up on every workbook that I open.





All times are GMT +1. The time now is 12:53 PM.

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