resetting page breaks

G

Guest

Ok, I was messing around with the location of the page breaks on one of my
worksheets, seeing how I could change what information was included on each
page. Now I want the page breaks to return to the default settings, but I
can't find anything that would show me how.

Any suggestions?
 
D

Dave Peterson

Maybe...

Select all your cells (ctrl-a (twice in xl2003))
Insert|Reset all page breaks
 

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
Remove page breaks 2
Page breaks won't budge 2
Improper Page Breaks 1
Print auto page breaks 1
Print preview/page set-up is printing 100's of blank pages 2
Why do page breaks change in excel when spreadhseet sent as email 2
Setting Page Breaks 1

Top