how to remove page breaks from an existing document

K

kidsgalore

I have an excel spreadsheet with teachers names, etc. How can I remove all
the page breaks from the document at one time.
 
G

Gord Dibben

Assuming you mean manually set pagebreaks.

View>Pagebreak View

Right-click on any cell and "Reset pagebreaks"


Gord Dibben MS Excel MVP
 

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

Excel Delete Multiple Page Breaks w/in Selected Rows 6
Page number problems with Word 0
How can I insert data into my spreadsheet without the page breaks. 1
how do i remove page breaks in excel? 1
Excel 2007 Page Break Adjustments causes a page break each cell 1
Correcting Page Numbering with Section Breaks 3
Inserting page breaks 3
find and remove page breaks 1

Top