Removing a page break from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Use the menu command View|Page Break. Now you can select and delete any and
all page breaks
best wishes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access How to prevent subReport from breaking across pages? 1
page breaks and printing 0
Excel 2007 Page Break Adjustments causes a page break each cell 1
Excel Delete Multiple Page Breaks w/in Selected Rows 6
Printing and scaling: why does Excel behave in such a way? PLZ HELP!!! 5
PAGE BREAK PREVIEW 1
linking a value from another page or tab in a formula 1
Why do page breaks change in excel when spreadhseet sent as email 2

Back
Top