ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Removing a page break from excel (https://www.excelbanter.com/excel-worksheet-functions/35151-removing-page-break-excel.html)

Na'an

Removing a page break from excel
 
I found a page break in a file at work. And my boss and I are trying to get
rid of it, because it's cutting off some of the spread sheet, and weirdly
enough, it's not showing up on the next page like it would normally. We have
the pages setup up as landscape so the entire spread sheet fits onto the
page. But on this page with the pagebreak, the spread sheet would fit,
accept the break is there. How do I remove this break?

David Jessop

Hi,

On the View menu, click Page Break Preview. Then to remove page breaks drag
the page break outside of the print area. To remove all manual page breaks,
right-click any cell on the worksheet, and then click Reset All Page Breaks.

HTH,

David

"Na'an" wrote:

I found a page break in a file at work. And my boss and I are trying to get
rid of it, because it's cutting off some of the spread sheet, and weirdly
enough, it's not showing up on the next page like it would normally. We have
the pages setup up as landscape so the entire spread sheet fits onto the
page. But on this page with the pagebreak, the spread sheet would fit,
accept the break is there. How do I remove this break?


Bernard Liengme

Use the menu command View|Page Break. Now you can select and delete any and
all page breaks
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Na'an" wrote in message
...
I found a page break in a file at work. And my boss and I are trying to
get
rid of it, because it's cutting off some of the spread sheet, and weirdly
enough, it's not showing up on the next page like it would normally. We
have
the pages setup up as landscape so the entire spread sheet fits onto the
page. But on this page with the pagebreak, the spread sheet would fit,
accept the break is there. How do I remove this break?





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

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