ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   resetting page breaks (https://www.excelbanter.com/excel-discussion-misc-queries/23722-resetting-page-breaks.html)

Weekend user

resetting page breaks
 
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?

Dave Peterson

Maybe...

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



Weekend user wrote:

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?


--

Dave Peterson


All times are GMT +1. The time now is 02:51 AM.

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